AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.
N54385Mattiello Scott C · Fernandina Beach, FLN5438BMoore Ryan T · Nampa, IDN5438DGanter Lewis C · Sherman, TXN5438ECsp Aviation LLC · Stuart, FLN5438WHoward Arthur L · Lake City, MNN54390Mcclelland Kip · Douglas, GAN54391Still Water Security Co LLC · Meriden, CTN54396Dicey Aviation LLC · Somerset, KYN54398Lashback Communications LLC · Farwell, MIN5439CLopez Hugo E · Mcallen, TXFirst renewal noticeN5439HMeyer Aviation Group LLC · Grand Island, NEN5439KEastern Kentucky University · Richmond, KYN5439LHasroun Andy · Sun Valley, CAN5439WRegistration Pending · Gary, SDRegistration pendingN543AHEquinox Aviation LLC · Albany, GAN543AMPikes Peak Flyers Llp · Colorado Springs, CON543BCRoeloffs Arie · Wendell, IDN543BZBravo Zulu LLC · Atlanta, GAN543CPPonnequin Craig R · Marsing, IDN543CWCentral Washington University · Ellensburg, WAN543DGrantham Ray · Sevierville, TNN543DGGavora Daniel E · Fairbanks, AKN543EMPacific Air Flight School LLC · Long Beach, CAN543EREmbry-Riddle Aeronautical University Inc · Prescott, AZN543FLMorpac Aviation Inc · Wayne, NJN543GTPathfinder Aero Services LLC · Sheridan, WYN543JDSybesma Troy S · Claremont, MNN543JRRahns Inc · Enterprise, ORN543MACorbett Mark K · Oshkosh, WIN543MCJoe Morten & Son Inc · S Sioux City, NEN543NDN543nd LLC · Manassas, VAN543POracle Aviation LLC · Omaha, NEN543PUByc Trucking Services LLC DBA · Norco, CAN543RBBaron Aviation LLC · Calera, ALN543RRFrank Carl · Bakersfield, CAN543RVWipprecht Robin D · Hot Springs, ARN543SGHall Linda L · Southport, FLN543SKGreene Scott P · El Paso, TXN543STR&K Aviation LLC · Fresno, CAN543TZulu LLC · Hattiesburg, MSN543THRidgeline Assets LLC · Wilmington, DEN543UCAllred Bradly James · San Francisco, CAN543VWich Robert · Norfolk, VAN54401Martin Duane C · Brownsburg, INN54405Noel Michael R · Tucson, AZN5440BCline Thomas E · Santee, CAN5440EK & A Aviation Inc · Barnegat, NJN5440KTwenty Two Juliet LLC · Tyler, TXN5440LNapoli Jeffrey D · Hillsborough, NJN5440NKenosha Airmens Flying Club Inc · Twin Lakes, WI
Back to AD 2007-04-19 R1