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.
N3166FShelton K Trustee · Perrysburg, OHN3166RVarnson Dale B · Brocket, NDN3166ZDarr J L III · Trinity, NCN31678Dodson International Parts Inc · Rantoul, KSN3167BCarelli Paul Anthony · Bonners Ferry, IDN3167DOrtlip Stephen A · Kenbridge, VAN3167FGreen James C · Cedar Rapids, IAN3167SLightning Bolt Aviation LLC · Bozeman, MTN3168CRegistration Pending · Anchorage, AKRegistration pendingN3168DBovee John W Or · San Diego, CAN3168PMaxwell Aviation Holdings LLC · Kalispell, MTN3168RRunck Russell E · Watertown, MNN3168WBlack Gold Flying Club Inc · Belvidere, NJN3168YSkydive Central New York LLC · Weedsport, NYN31694Rey Al · Burlington, NCN31696Wigmor · Salem, ORN31699Donahue Investments LLC · Port Orange, FLN3169LPhillips James A · Burlington, WIFirst renewal noticeN3169TOwen James D · Fort Lauderdale, FLN3169WCoelho Enterprises Inc · Dayton, NVN3169ZBixler Tyke L · Massillon, OHN316ACheng Williams W · North Potomac, MDN316ACBillings Brian · Bondurant, WYN316ASChristiansen Aviation LLC · Wilmington, DEN316AZHeli Thrills LLC · Wills Point, TXN316BHHoover Donald Scott · Chugiak, AKN316BT316 Bravo Tango LLC · Austin, TXN316CAChoice Aviation LLC · Hamilton, MTN316CDRegistration Pending · Fort Worth, TXRegistration pendingN316CWWwc Sky Holdings LLC · Wilmington, DEN316CZGoins Alexander · Heiskell, TNN316DBShane Douglas B · Venice, CAN316DCAb Prop Plane II LLC · Metairie, LAN316DFThacker Orbie A · Wellington, ALN316DSJensen Jared · Richfield, UTN316EFLibra Air Inc · Las Vegas, NVN316EPMustang Sally Aviation LLC · Camden, SCN316HCChilders Henry Dr · Lewes, DEN316HYLakeview Aviation Inc · Newport, VTN316JDMartinez Steven · Upland, CAN316JGKoch Eric R · Jasper, TXN316JHNorthern Arizona Investment Group LLC · Prescott, AZN316JRTrinity Graphics Inc · Helena, MTN316KBTraweek Parrish C · San Manuel, AZN316LFFurlong Kelly L · Athens, ALN316LRLake Wendell · Madison, WIN316LSC M & N D Inc · Wilmington, DEN316MMattson Douglas L · Dike, IAN316MLJump N316ml LLC · East Berlin, PAN316NDCirrus Aviation Inc · Sarasota, FL
Back to AD 2007-04-19 R1