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.
N4158BCapristo Construction · Cape Coral, FLN4158DBoho LLC · Lewes, DEN4158LJm Lavore Aero Inc · Lakeside, MTN4158WButler John P · Hazelhurst, WIN4158YAlliance Aircraft Sales Inc · Pierre, SDN4158ZSchaetzel Paul Robert · New Meadows, IDN41593Flyin LLC · Hyde Park, UTN41594Butler John P · Hazelhurst, WIN41598Fox Flying Club Inc · Wheaton, ILN41599Tiger Helicopters LLC · Baton Rouge, LAN4159AHauser Associates Inc · Coral Gables, FLN4159DBachman Aviation LLC · Independence, IAN4159KRegistered aircraftN4159PSparks Brian E · Monmouth, ORN4159SCrew Marshall D · Spokane, WAN4159TGholami Amir H · Santa Rosa, CAN4159XHagglund Carl D · Pendleton, ORN4159YBauer Aviation LLC · Reese, MIN415AMUtah State University · Logan, UTN415BHCentral Airlines Inc · Overland Park, KSN415CAFly For Fun Aircraft LLC · Baltimore, MDN415CCCsc Delaware Trust Co Trustee · Wilmington, DEN415CFAlo Fliteline Lc · Waterloo, IAN415DHSparks Group Inc · Jay, OKN415ECCreativity Before Capital LLC · Tampa, FLN415GB415gb LLC · Encinitas, CAN415GEN415ge LLC · Wilmington, DEN415GFSouthern Aircraft Consultancy Inc Trustee · Casper, WYN415GKCentral Clinton County Flying Club Inc · Jersey Shore, PAN415GSKirkman Robert Nolan · Pilot Mountain, NCN415HPRichmond George H Jr · Elkhorn, NEN415JBBrewer Allen E · Madison, MSN415JLOlson Douglas W · Yarmouth Port, MAN415JSCarey James A · St Charles, ILN415KGSky Safety Inc · San Antonio, TXN415LLost Pines Tours LLC · Bastrop, TXN415LEStadelman Edwin F · East Falmouth, MAN415MEngelien Wendell · Port Orange, FLN415MDHammychan Industries LLC · Glendale, AZN415MRKropp Matthew M · North Creek, NYN415MSNextgen Flight Academy Inc · Riverside, CAN415PABird Acquisition LLC · Phoenix, AZN415PJPalm Springs Air Museum · Palm Springs, CAN415RGalyon Aviation LLC · Sweetwater, TNN415RABoas Mark S · Hollywood, MDN415RCAvco Patrol LLC · Lyndon, KSN415RJAviation Training LLC · Wilmington, DEN415RPRotorpro LLC · Sevierville, TNN415RWSale Reported · Jasper, ALSale reported, pending cancellationN415SGriffing Flying Service Inc · Port Clinton, OH
Back to AD 2007-04-19 R1