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.
N377THMenard Keith L · Bellevue, TXN377TMQualitair LLC Trustee · MichelstadtN377WBradley Aviation LLC · Whiteland, INN377WMQualitair LLC Trustee · MichelstadtN37809Cavanagh Michael B · Dubois, WYN3780TBowley Leonard · Newton, ALN3780WRaines Marshall A Jr · Whiteside, TNN3780ZBenoit Robert W · Hot Springs, ARN3781DHelmer Douglas A · Avon, INN3781KBomar Tami J · Gig Harbor, WAN3781LCarmel Aviation Inc · Boise, IDN3781PHoogendorn Homer E · Wasilla, AKFirst renewal noticeN3781QWelch Michael R · Roanoke, TXN3781UN3781u LLC · Key West, FLN3781XN3781x LLC · Puyallup, WAN3781YPhillips Holly N · Reed Point, MTN3782RFreeman William B Jr · Southington, CTN3782UOttmer Mark L · Pearce, AZN3782XBrown David L · Flemington, WVN3783Midwest Fling Service Inc · Elgin, NEN3783PMcdaniel Robert M · Tonasket, WAN3783YThompson Arthur H Jr · Hereford, AZN3783ZSchulz Kevin J · Clearlake Park, CAN3784KBurr Walter E · Tecumseh, MIN3784NMorcott Ian · Mountain Home, IDN3784WBas Part Sales LLC · Greeley, CON3784YQualitair LLC · MichelstadtN3785DKing John H · Trumansburg, NYN3785QGo Fly Missoula LLC · Missoula, MTN3785TZeuner John F · Austin, TXN3785XWalker Dennis H · Tyler, TXN3785YNational Snake Team LLC · Benton, LAN3786BWright B Flyer Inc · Miamisburg, OHN3786TSunrise Aviation Inc · Ormond Beach, FLN3786WDavis William K · Fredericksburg, VAN3786XTinaglia J Dean · Hot Springs, SDN3786YWilliams John D · Geneva, OHN3787POdonnell Daniel V · Dover, DEN3787QBarron Nicholas Samuel · Alma, ARN3787UCcd Aviation LLC · Gardnerville, NVN3787ZEasterday Jay A · Wilder, IDN37880Mississippi State University · Starkville, MSN37887Metzler Kevin W · Rosamond, CAN3788QSale Reported · Oklahoma City, OKSale reported, canceledN3788TMason Kenneth Lee · Siloam Springs, ARN3789DBeasley Charles J · Batesville, ARN3789GMentor 89g LLC · Kalispell, MTN3789QHercules Jesse T · Memphis, TNN3789TGullett John H II · Jacksonville, FLN378AKRegistration Pending · Anchorage, AKRegistration pending
Back to AD 2007-04-19 R1