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.
N289PSWillkris Aviation Services LLC · Smithfield, VAN289RBarrows Robert E · Fincastle, VAN289SAReed Gary · Bethel, OHN289SBHemcka Aviation LLC · Bradenton, FLN289SRFedora Lisa L · Southampton, MAN289STSml Aviation LLC · Parker, CON289WDDunn William M · Malibu, CAN289WLHutchins Reid C · Hanover, NHN289WRBradbury Douglas W · Pedro Bay, AKFirst renewal noticeN28ACZiegler Bruce A · Findlay, OHN28AGZahler Mitchell J · Stillwater, MNN28AHFuiten Roger C · Denali Park, AKFirst renewal noticeN28APAircraft Trust & Financing Corp Trustee · Wilmington, DEN28AUAndrews University · Berrien Springs, MIN28AWSkyhook Inc · Nescopeck, PAN28AXMotion Works LLC · Green Cove Springs, FLN28BRFlying Rock Aero LLC · Sunnyvale, CAN28BTBi-Plane Training LLC · Saint Louis, MON28BWJv Aviation Group Inc · La Puente, CAN28CCGulf Airbatics Ltd · Jennings, LAN28CEKohles Aviation LLC · Norfolk, NEN28CMFiorita Vincent L · Wooster, OHN28CNRoman Stephen B · Minnetrista, MNN28CPArk Investments Inc · Ridgeland, MSN28CRKeating Lawrence A · Newark, DEN28CSEmerald Aero LLC · Pace, FLN28DBEdson Franz R · Waterford, CTN28DJMccrorie David M · Port Angeles, WAN28DKBoudreau Robert D · Rusk, TXN28DLTrzynka Dean A · Iron River, WIN28DTSilverstreak Aviation LLC · The Villages, FLN28DWDavid E Glaser LLC · Peyton, CON28EHChapin Ray DBA · Geneva, NYN28EJRegistered aircraftN28EKKalabus Edward A Jr · Dallas, TXN28ERSmith John C · Germantown, TNN28EWEdwards Jason L · Lone Rock, WIN28FACivil Air Patrol · Maxwell Afb, ALN28FFCaicedo David · Villa Rica, GAN28FXSouthern Aircraft Consultancy Inc Trustee · Casper, WYN28GMooneyham Mark · Auburn, CAN28GKMay Aviation LLC · San Diego, CAN28GMForinger Mark A · Pinehurst, NCN28HCGingras John T · Bakersfield, CAN28HGHill Donald G · Westerly, RIN28HHSmith Helicopters Inc · Cotulla, TXN28HPFrowe Robert E · Lake Dallas, TXN28HUKahonees Air Service LLC · Bozeman, MTN28HYBeavers Air LLC · Fort Walton Beach, FLN28JAJersey Aero Club Inc · Lakewood, NJ
Back to AD 2007-04-19 R1