AD 87-10-06 R1
Registered aircraft · 72,010
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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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.
N9458JTibbitts Dennis C · Woodstock, ILN9458NSwaz Aviation LLC · Mesa, AZN9458PAmerican Standard Aviation LLC · Burleson, TXN9459Sullivan Stanley D · South Jordan, UTN9459NEngel Stephen J · Plymouth, INN9459PRegistered aircraftN945DBHoskins Joshua C · Frisco, TXN945DPPeer Thomas A · Tullahoma, TNN945DSKnox Matthew · New Carlisle, OHN945EBFlying Z LLC · East Lansing, MIN945FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLN945GBWarbalow Peter R · Minocqua, WIN945LBAllegro Jeff · Upper Lake, CAN945PDHickmott Mark T · Sunol, CAN945PLWheatley John P Jr · Thorp, WAN945SMFive Rivers Flight Training LLC · Livermore, CAN945TC R Transport Inc · Wilmington, DEN945TADms Aviation Services LLC · Wildwood, MON945TELebanon Flying Club Inc · Lebanon, TNN945TLShirley Mae LLC · Franklin, MIN945UMd Ag Services LLC · Sterling City, TXN945VKTiedemann Daniel W · Carmel, INN9460BEdwards Ag Service · Primghar, IAN9460DOlsen Marr B · Kelseyville, CAN9460JDerosa Michael D · Hewitt, TXN9460VDodie Aviation LLC · Sheridan, WYN9461CClub Cherokee Inc · Crystal, MNN9461DDurghinescu Cris Nicolae · Rancho Mirage, CAN9461JKobbeman Joseph B · Louisville, KYN9461NJames Neville & Company Inc · Ocala, FLN9461PErickson Jess L · Saco, MTN9461VZembraski Jeffrey · Nocona, TXN9462DEvans Randall Btrustee · Fallon, NVN9462NLombardo Gene S · New Bern, NCN9463DHarris Aircraft Leasing Co · Oklahoma City, OKN9463KRegistered aircraftN9463VHatcher Mark F · Aloha, ORN9463WHassebroek Leroy A · Little Rock, IAN9464D907 Aviators LLC · Eagle River, AKN9464JReinert Roger J · Duluth, MNN9464NTempleton Katherine M · Madison, WIN9464WHollingsworth Ronald W · Shawnee, KSN9465DMehrer Fritz J · Oceanside, CAN9465JTaylor Robert J · Woodbridge, VAN9465NStenhouse Place I LLC · Fountain Inn, SCN9465PFtb Aviation LLC · Arden, NCN9466DGerrard Michael K · Kaysville, UTN9466EGood Flight Aviation LLC · Stockton, CAN9466JHawk Aviation Academy LLC · Saint Petersburg, FLN9466KSpanaflight LLC · Puyallup, WA
Back to AD 87-10-06 R1