AD 80-25-07 R1
Registered aircraft · 25,370
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:80-25-07-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-07-R1')
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:80-25-07-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-07-R1') 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.
N538EELight Speed Air LLC · Los Angeles, CAN53900Nielsen Jeffrey A · Frankfort, MIN53901Aero Flight Dynamics LLC · Riverside, CAN53902Jackson Todd · East Wenatchee, WAFirst renewal noticeN53903Campbell Kasey W · Thornburg, VAN53904Sundblad Ryan M · Albert City, IAN53905Registered aircraftN53906Mock George M · Jackson, GAN53907Sakalaskas Jason · Fairbanks, AKN53909Rawlings Cecile Cole · Palatine, ILN5390VSpringfield Flying Service LLC · Columbia, CAN53912Rider R.P. Field · New Gloucester, MEN53914Kauzlarich Steve F · Oakland, CAN53918N53918 LLC · Charles City, IAN53919Alexander Aviation LLC · Brighton, CON5391ASingh Amandeep · Stockton, CAN5391HHansen Alvin Kent · Winamac, INN5391TV Y Aviation LLC · Gentry, ARN53920Aero Dragger Ltd · Warminster, PAN53922Medford Pat G · Phoenix, AZN53923Little Dale E · Marshville, NCN5393VPeterson Gary E · Bainbridge Island, WAN53945Lewis Robert · Chandler, AZN5394BRichmor Aviation Inc · Hudson, NYN53952Oancea Traian · Oakdale, CAN53954Markey Jim F · Pocahontas, ILN53955Windsor Brian · Colfax, WAN53959Tailwheel Adventures LLC · Orlando, FLN5395HHansen James R · Kenmore, WAN53960Iflytail LLC · Granbury, TXN53962Hatbright Farm LLC · Wilmington, DEN53965Robbennolt Steve L · Gettysburg, SDN53966Harris Kenneth L · Greeley, CON53968Martin John H · Wasco, CAN5396ESorbi Aviation Inc · El Cajon, CAN53970Ripley James III · Frederick, OKN53975Cox Kelsi J · Williamsburg, IAN53977Bosick Gregg A · Kasilof, AKN53978Sanborn John M · Wasilla, AKN5397DRandall William G · Oklahoma City, OKN5397RIowa Lakes Community College · Estherville, IAN53982Pearson Scott A · Tipton, IAN53983Johnson David H · Jasper, GAN53984Horton Brad L · Lavernia, TXN53986Flyit LLC · Camas, WAN53988Jensen Marian D · Auburn, WAN53996Pea-Wayman Flight LLC · Daytona Beach, FLN5399BLudian Malgorzata · Bakersfield, CAN5399JMann Aviation Inc · Long Beach, CAN5399KColemanation Investments LLC · Naperville, IL
Back to AD 80-25-07 R1