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.
N3138URegistered aircraftN3138WN3138w Bonanza V35b LLC · Jeffersonville, INN31396Pucciarelli Albert J · Ridgewood, NJN31397Ial Corp · Lewes, DEN31399G&M Aircraft Inc · Wheat Ridge, CON3139DGuichard Lawrence · Spokane, WAN3139LOn Premise LLC · Hannibal, MON3139QGrubbs Jerry M · Longview, TXN3139WGrace Air LLC · Kalispell, MTN313AAAviator Air Operations LLC · Grand Prairie, TXN313ACAero Craft Of Bloomington LLC · Bloomington, ILN313AMRademacher John · Cottonwood, AZN313BLDaggett Keith W · Rockport, MEN313CHSlater Timothy R · Poplar Grove, ILN313CPCivil Air Patrol · Maxwell Afb, ALN313CWJackson Kimberly L · Show Low, AZN313CZBuckley Robert L Jr · Castle Rock, CON313DDunlap Charles R · Pima, AZN313DCRegistered aircraftN313DDAlpine Air Aviation LLC · West Haven, UTN313DG3dg Aviation LLC · Louisville, KYN313DQIler Elden · Van Nuys, CAN313EJBohrman Ken C · Pebble Beach, CAN313FFerguson John Edward · Santa Ysabel, CAN313GALittle Craig · Oregon City, ORN313GBBurnett Gregory C · Rogersville, MON313GMEugene C Warne Trustee · Alamo, CAN313GTRegistered aircraftN313GWWright George E Jr · Homestead, FLN313HTKiernan Bernard J · Hopewell Junction, NYN313JHJam Three LLC · St George, UTN313JVScholze Jerome V · Anchorage, AKN313JWWright George E Jr · Homestead, FLN313KDOdonnell Daniel Gordon · Plymouth, MAN313LNBazal Jared W · Castle Rock, CON313MBosco74 LLC · Wilmington, DEN313MAAbrams David · Holmdel, NJN313MPAlpha Bravo Charlie 1 Corp · Houston, TXN313MTNguyen Nhu-An T · Parkville, MDN313MWClover George S · Catheys Valley, CAN313PSHier Richard T · Lambert, MTN313RJNew Hampshire Flying Association Inc · Nashua, NHN313RTBuechler James K · The Villages, FLN313RVBusbea Shawn · Conway, ARN313RWSarp Rentals LLC · Loudon, TNN313SKJohnson Scott · Blaine, MNN313TAD A Consulting Inc · Orlando, FLN313TDCfi Care Inc · Oxford, CTN313TF313tf Aviation LLC · Superior, WIN313WWilliams Thomas James · Clovis, CA
Back to AD 2007-04-19 R1