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.
N53758Trailing Edge Aviation LLC · Lancaster, PAN53759Pacific Lease · Elk Grove, CAN5375JDaviss Joseph A · Sylacauga, ALN5375LDerose Kevin L · Janesville, CAN5375RArctic Flying Club · Fairbanks, AKN5375WOverly Christopher D · Williamsport, OHN53763Anderas Per R · Green Bay, WIN53764Push To Talk Aviation LLC · Burr Ridge, ILN53769Holcomb Garry · Greenville, TXN5376HPires Fernando L · Hilmar, CAN5376JTss Aviation LLC · Conyers, GAN5376PDuffield Michael · Sorrento, FLN5376WJenkins Walter J · Mayfield, UTN53772Quale Scott M · New Town, NDN53773Brock Edwin G · Hawthorne, FLN53777Bernabucci Christian J · Mapleton, NDN5377CAnderson Robert C · Zanesfield, OHN5377DDesantis Anthony · Memphis, TNN5377HSchmid Gerhard G · New Smyrna Beach, FLN5377PRegistration Pending · Litchfield Park, AZRegistration pendingN5377SHicks James S & Hicks Sally J Edgar Trustee · Oregon City, ORN5377VShoemake Stephen Sidney · Pine Mountain, GAN5377WJackson Timothy J · Hartselle, ALN5377ZTurner Edward J III · Mokena, ILN53781Hayden Aviation LLC · Rhome, TXN53785Fox Business Advisors LLC · Mesa, AZN53787Jones Carl L Jr · Edmond, OKN5378BDraper Floyd L · El Paso, TXN5378DMustang Sally Aviation LLC · Camden, SCN5378ENuxoll Randy G · Eagle, IDN5378HFellman Peter A · North Chatham, MAN5378KUnique Educational Experiences Inc · Signal Hill, CAN5378LPeterson Dru J · Riverside, CAN5378WHargis Bookman LLC · Justin, TXN5378YRagwing Flyers LLC · Richmond, TXN53791Maseman Paul A · Tucson, AZN53794Rick Aviation Inc · Newport News, VAN53797Christiansen Aviation LLC · Wilmington, DEN5379SStevens Michael J Trustee · Park City, UTN5379YHandly William A · Arcola, MSN5379ZMcelwee Glenda A · Lake City, FLN537APa28 Aircraft LLC · Wilmington, DEN537ACMacmillan John Jr · Chevy Chase, MDN537CCKincaid James B · Hamilton, MTN537CLAckerman Terry L · Brookings, SDN537DMKrakoff Matthew · Massapequa, NYN537EREmbry-Riddle Aeronautical University Inc · Prescott, AZN537FLHanson David Lawrence · Tucson, AZN537HPBarr Air Patrol LLC · Mesquite, TXN537JHBuffington Matthew Hill · Highlands Ranch, CO
Back to AD 81-18-04 R2