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.
N733KKBend Aircraft Mechanics LLC · Bend, ORN733KSChaffin Grant M · Blythe, CAN733KTCardin Thomas W · Kearney, MON733KVSutton Aircraft Salvage LLC · Palmer, AKN733LEChagres Flight Training LLC · Albuquerque, NMN733LFPerfect Speed LLC · Burlington, MAN733LKSkyvue Aerial Photos LLC · Leipsic, OHN733LLLavalley Asset Management Inc · Potsdam, NYN733LMAlstrom Ragnar O · Alakanuk, AKN733LNJohn D Strohsahl Pa Trustee · Fort Lauderdale, FLN733LPDg Aviation Services Inc · Merritt Island, FLN733LQFarriss James W · North Lawrence, OHN733LSResearch Flight Inc · Wayzata, MNN733LYLong Island Aviators LLC · Seaford, NYN733MCMann Aviation LLC · Wilmington, DEN733MDPaul R Berg Pa · Vero Beach, FLN733MGBend Aircraft Mechanics LLC · Bend, ORN733MLJennings Jacqueline L · Rome, NYN733MPCrawford Alan R · Buchanan Dam, TXN733MSNorthgate Aviation Inc · Chico, CAN733MTWashington Rodney · Mitchellville, MDFirst renewal noticeN733MUSanford Aircraft LLC · Winter Springs, FLN733MVHarvey Paul E · Richmond, MEN733MWWebb Matthew · Denton, TXN733MXWaldron Ronald · Strongsville, OHN733MZAnderson Christen M · Tulsa, OKN733NBTexins Flying Club · Mckinney, TXN733NCRrgsoftware LLC · Alpine, CAN733NDBas Part Sales LLC · Greeley, CON733NEHollenhorst Thomas More · Northfield, MNN733NFSchoch George J · Lakewood, WAN733NKClassic Aviation Inc · Pella, IAN733NPN733np LLC · Port Orange, FLN733NQPerlman Elliot M · Providence, RIN733NRGreer Miles · Many, LAN733NVAero Maintenance Inc · Vancouver, WAN733NWLeatherwood John W · Corinth, MSN733PDThree Tree Aviation LLC · Natchez, MSN733PGPn Aero LLC · Caldwell, NJN733PNAerospring Leasing LLC DBA · Wasilla, AKN733PQSeppmann Benlyn · Lake Crystal, MNN733PVCalifornia Airways LLC · Hayward, CAN733PXWest Bend Air Inc · West Bend, WIN733PYRsa Flight Training LLC · Morgantown, WVN733QHall Jeffrey L · Cedar City, UTN733QAParrillo Development And Real Estate LLC · Sarasota, FLN733QGCarter Flygare Inc · Sacramento, CAN733QHSt Charles Flying Service Inc · Portage Des Sioux, MON733QJRick Aviation Inc · Newport News, VAN733QQHenley Johnny J · Trenton, NC
Back to AD 81-18-04 R2