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.
N3276DFarkas Jonathan · Mukwonago, WIN3276PFly Rite Aviation LLC · Fort Myers, FLN3276SLewinsky Marlon · Carrollton, TXN3276UNk Innovations LLC · Spokane, WAN32773Dalba Andrew Naim · Anaheim, CAN32779Bcm Enterprise LLC · Phoenix, AZN3277CSandstrom Mark R · Minot, NDN3277MSmith Carmen Marie · Juneau, AKN3277SBayless Smoky · Coronado, CAN3277YLapinsky Richard G · Los Lunas, NMN3277ZBacklund Scott W · Greybull, WYFirst renewal noticeN32781Arends Aviation And Instruction LLC · Mahomet, ILN32783Frederick Michael A · Cleves, OHN32784Denicola Frank J · Visalia, CAN32785Registration Pending · Kodiak, AKRegistration pending, pending cancellationN3278SStrong Brian S · Southport, NCN3278UCarver Thomas G · St Maries, IDN3278WEvans Jacob · Mona, UTN32790N32790 LLC · Avilla, INN32793Garrido Albert · Kensington, CTN32794Gilbert Thomas D · Gladstone, MIN32796Mcvey Austin L · Lakewood, CON3279CHunsucker Michael A · Seguin, TXN3279DDavies James E · Eagle, IDN3279MValiair Limited Co Trustee · Casper, WYN3279NTips Frederick J III · San Antonio, TXN3279PSouth Bay Flight Training Center · Carolina, PRN3279USchlafmann Jay R · Mercer, NDN3279YCrisler Garret · Rice Lake, WIN327ABN327ab LLC · Omro, WIN327AKPearce David W Trustee · Anchorage, AKN327AMSchmidt Steven P · West Springfield, VAN327BEBlack Swamp Flyers LLC · Fremont, OHN327BLCinotto Robert L · Rhome, TXN327BWCessna N327bw LLC · Telluride, CON327CPSu Farms Transportation LLC · Hale Center, TXN327CTYr-Aircraft Leasing LLC · Bethel, AKN327DBonanza Flyers LLC · Aurora, CON327DGSabino Sean · Ames, IAN327DMMullin Clint · Lambert, MTN327DPZamboni Fisheries LLC · Ketchikan, AKN327DTLafferty Jason · Marana, AZN327EDKrejsa David L · Chagrin Falls, OHN327FFoster Gary R · Mineola, TXN327GSkysix Aircraft Management LLC · Saginaw, MIN327HBMatthews Michael B · Statesville, NCN327HRRd Holdings LLC · Las Vegas, NVN327LLMeehan Patrick K · Willow, AKN327LSHeermann Philip D · Albuquerque, NMN327LWPerini Stephen Dale · Fayetteville, GA
Back to AD 2007-04-19 R1