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.
N5437LRegistration Pending · Toquerville, UTRegistration pendingN5437PDeplorable Air LLC · Lakeland, FLN5437RSchafer Brian L · Carleton, MIN5437WRoutson David P · Dundee, MIN5437YHayman Russell P · Ocean City, MDN54381Paradise South Ventures LLC · Marco Island, FLN54384Above All Aviation Inc · Goleta, CAN54385Mattiello Scott C · Fernandina Beach, FLN5438WHoward Arthur L · Lake City, MNN54390Mcclelland Kip · Douglas, GAN54391Still Water Security Co LLC · Meriden, CTN54396Dicey Aviation LLC · Somerset, KYN54398Lashback Communications LLC · Farwell, MIN5439HMeyer Aviation Group LLC · Grand Island, NEN5439KEastern Kentucky University · Richmond, KYN5439LHasroun Andy · Sun Valley, CAN5439WRegistration Pending · Gary, SDRegistration pendingN5439ZCarbiener Ross E · Kewanee, ILN543AHEquinox Aviation LLC · Albany, GAN543AMPikes Peak Flyers Llp · Colorado Springs, CON543CPPonnequin Craig R · Marsing, IDN543CWCentral Washington University · Ellensburg, WAN543EREmbry-Riddle Aeronautical University Inc · Prescott, AZN543FLMorpac Aviation Inc · Wayne, NJN543GTPathfinder Aero Services LLC · Sheridan, WYN543JDSybesma Troy S · Claremont, MNN543JGWessel Marvin E Jr · Chandler, AZN543MACorbett Mark K · Oshkosh, WIN543MCJoe Morten & Son Inc · S Sioux City, NEN543NDN543nd LLC · Manassas, VAN543POracle Aviation LLC · Omaha, NEN543PUByc Trucking Services LLC DBA · Norco, CAN543RRFrank Carl · Bakersfield, CAN543RVWipprecht Robin D · Hot Springs, ARN543SGHall Linda L · Southport, FLN543STR&K Aviation LLC · Fresno, CAN543THRidgeline Assets LLC · Wilmington, DEN543UCAllred Bradly James · San Francisco, CAN54401Martin Duane C · Brownsburg, INN54405Noel Michael R · Tucson, AZN5440EK & A Aviation Inc · Barnegat, NJN5440KTwenty Two Juliet LLC · Tyler, TXN5440LNapoli Jeffrey D · Hillsborough, NJN5440PWurlitzer Lindsay Pabst Trustee · Healdsburg, CAN5440ZWroe Daniel C · Denton, MDN54410Law Aircraft LLC · Oak Grove, MNN54412Flight Time Builders Inc · Memphis, TNN54413Belcher Phillip B · Claremore, OKN54414Panjab Aviation Inc · Las Vegas, NVN54416Glenn Richard L · York, PA
Back to AD 81-18-04 R2