AD 81-18-04 R2
Registered aircraft · 81,733
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N907CUDenny Roger A Jr · Eagle River, AKN907DTLanni Douglas W · Fairbanks, AKN907EEmbley Tommy Jene · Anchorage, AKN907EPEpic Aviation Inc · New Smyrna Beach, FLN907FVGuthrie Richard A · Anchorage, AKN907GDAir Charter Inc DBA · Culebra, PRN907GJKincaid Levi L · Palmer, AKN907GPGittlein Paul A · Wasilla, AKN907HHarding Jason I · Wasilla, AKN907HGDenali North Side Adventures LLC · Wasilla, AKN907HRMerrill Andrew T · Bethel, AKN907JConaway Jeffrey Scott · Anchorage, AKN907JAAnderson James C · Wasilla, AKFirst renewal noticeN907JD27th Aero Squadron LLC · Phoenix, AZN907JJJackson Justin R · Valley Center, KSN907JSStevenson William E · Sutton, AKN907JWPalm Beach Flight Training Corp · Lantana, FLN907KSKingsky Flight Academy LLC · Lakeland, FLN907KYYoung Richard H · Eagle River, AKN907LCCrowe Talmadge L Jr · Anchorage, AKN907LEAll Her Fault LLC · Fairbanks, AKN907LJAgl Aero LLC · Mckinney, TXN907LLAerial Ag Services LLC · Hillsboro, TXN907LPMicro Publishing Press Inc · Truckee, CAN907MWaitman Bradley J · Wasilla, AKN907NWDonelson Patrick M · Wasilla, AKN907PKBachus James Ross · Stephenville, TXN907PMMinelga Paul · Soldotna, AKN907PSBrock W Walker · Charleston, SCN907RDLynch James P · Santa Barbara, CAN907RUBlahut Michael · Anchorage, AKN907SCCrowe Talmadge Layne Jr · Anchorage, AKN907SEAlf Ix LLC · Chicago, ILN907STState Of Alaska Department Of Public Safety · Anchorage, AKN907THNovember Alpha LLC · Dover, DEN907TTHangar Ak LLC · Sterling, AKN907TWCarpenter Orin C II · Anchorage, AKN907UTClaus Paul E · Chitina, AKN907VCVision Cubs LLC · Deville, LAN907VLBlue Waters Air Charters LLC · San Juan, PRN907WAPea-Wayman Flight LLC · Daytona Beach, FLN907WBWooten Kevin W · Collinsville, ALN907WKNational Aircraft Leasing Corp · Manassas, VAN907WMSpano Darren M · Deville, LAN907XLLunenschloss Michael L · Anchor Point, AKN9080DTrieber Steven M · Eastport, MEN9080LStewarts Aircraft Service Inc · Waynesville, OHN9080YGorley Raymond W · Lees Summit, MON9081HRich Lucas Aircraft Sales LLC · Lincoln Park, NJN9081JPerkins Jimmy Keith · Lonoke, AR
Back to AD 81-18-04 R2