AD 2006-10-21
Registered aircraft · 44,908
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:2006-10-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21')
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:2006-10-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21') 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.
N122MENorton Mark Trustee · Stateline, NVN122MLLutz Michael A · Findlay, OHN122MWWalker Kyle E · Lawrence, KSN122PLSlip Stream Aviation Inc · Fort Mill, SCN122PMFrench Benjamen M · Dillon, MTN122RFDaniels Ronald C · Poughkeepsie, NYN122SGTanz LLC · Helena, MTN122TEBouchillon James R · Hanahan, SCN122TVButler Aaron · Rupert, IDN122VKWings Over Texas Holdings LLC · Denton, TXN122VUWeishaar Richard N III · Roselle, ILN122WEOhio State University · Columbus, OHN122YBRobinson Helicopter Co · Torrance, CAN1230EMcmahan Johnny W · Gakona, AKN1230GFlight Training Aircraft LLC · Wilmington, DEN1230SSpecialized Aero Works LLC · Bend, ORN1230TWings Over Texas Holdings LLC · Denton, TXN1230UPiper Aircraft Inc · Vero Beach, FLN1230XMarquez Christopher · Gaithersburg, MDN1231JMattson Paul · Chula Vista, CAN1231WMusa Adam · Princeton, NJN1232GDirty Side Down Aviation LLC · Georgetown, TXN1232WMilam David N · Hannibal, MON1233TJesteadt Ronald J · Conneaut Lake, PAN1234HSpear Tarik W · Fairbanks, AKN1234KLatiolais Travis · Breaux Bridge, LAN12354Spencer Christopher · Voorheesville, NYN1235ESale Reported · Lewes, DESale reportedN1235SBarney Erick L · Jacksonville, ORN1235XRudy Alan J · Phoenix, NYN1236TOtero Edgardo A · Tucson, AZN1236XFull Mooney LLC · Camden, DEN12381Bowers James E DBA · Galloway, OHN1238XAljo Aircraft Corp · Arroyo Grande, CAN1239PPinellas Pilots Association Inc · Clearwater, FLN1239TPhoenix East Aviation LLC · Daytona Beach, FLN1239XAircraft Ownership Solutions LLC · Kokomo, INN123AJRace 39 LLC · Kenmore, WAN123ALLambert Danny J · Plainview, TXN123ARRullan Alberto · Adjuntas, PRN123AXSouthern Aircraft Consultancy Inc Trustee · Casper, WYN123BBSingletrack Aviation LLC · Brecksville, OHN123BEBald Moutain Aviators · Fredericktown, MON123BRTwin Bee LLC · Groveland, CAN123BSLackie Stuart W · Swanton, VTN123BYRegistered aircraftN123CAInternational Air Services Inc Trustee · Carson City, NVN123CCColumbia Mooney LLC · Columbia, MON123CMSweet Wings Inc · Bethlehem, PAN123CPCivil Air Patrol · Maxwell Afb, AL
Back to AD 2006-10-21