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.
N35113Day Zandra Y · Boise, IDN35115Stern Gary · Yuma, AZN3511FHardison Charles M · Granbury, TXN3511KWilkins Sy · Jacksonville, NCN3511LPatty Brent A · El Dorado, KSN3511RWilliam E Boyle LLC · Pittsburgh, PAN3511TTippett Daniel W · Heath, OHN3511VCypress Creek Shooting Lodge LLC · Greenbrier, ARN3511YJ F Jones Logistics LLC · Dallas, TXN3511ZPogue Jimmy D · Owasso, OKN35120Hillard Mark L · Gettysburg, PAN35122Riggs Charles A · Pembroke Pines, FLN35128Lambo Air LLC · Springtown, TXN3512FNourbakhsh Illah R · Pittsburgh, PAN3512UN3512u LLC · Ruidoso, NMN3512XTaylor Logan · Live Oak, CAN3513FBeeca Flight LLC · Oviedo, FLN3513LDuden Brett R · Golden, CON3513TCrusade Investments LLC · Ardmore, OKN3513UDieck Michael N · Raleigh, NCN3513WFrankiewicz Victor J · Chrisman, ILN35143Premier Jets Inc · Hillsboro, ORN3514FSullivan Kelly J · Chandler, AZN3514KHollan Charles J · Columbia Station, OHN3514LFlying Horseman Ranch LLC · Stuart, VAN3514QReed Daniel E · Wentzville, MON3514UChristiansen Aviation LLC · Wilmington, DEN3514WBattaglia Anthony · Moosic, PAN3514YCielakie Edward W · Dracut, MAN35151Aac Leasing LLC · North Ferrisburgh, VTN35158Pearce Henry J · New Baltimore, MIN3515LBorchers Bruce A · Scotts Valley, CAN3515NClauson Jesse W · Agawam, MAN3515USchettler Patrick J · Garnett, KSN3515WHetherington Michael R · Fairbanks, AKN3515XSayre Mikko · Madison, WIN3515YInflyt LLC · Carlsbad, CAN35163Eagle Sky Patrol Inc · Deadwood, SDN35165N35165 LLC · Starkville, MSN3516FWhittock Tyson H · Anchorage, AKN3516GHepler William J · Gratz, PAN3516KSteitz John III · Antioch, ILN3516MAdamsup Aviation LLC · Wilmington, DEN3516XThompson Richard F · Boone, NCN3516YMks Aviation LLC · Port Orchard, WAN3517AMunoz Pedro L · Ontario, NYN3517NTronaas Chris E · Hamilton, MTN3517PSmith Mark A · Bowling Green, KYN3517SG & M Aircraft Inc · Wheat Ridge, CON3517VSt Cloud State University Aero Club Inc · Saint Cloud, MN
Back to AD 2007-04-19 R1