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.
N44597Tob Cherokee Flyers · Kasson, MNN4459HClements Edward L · Fruita, CON4459JCoastal Virginia Aviation LLC · Chesapeake, VAN4459SJameson Kelly J · Chappell Hill, TXN445ACTholen Susan M · Kennebunk, MEN445AFPlane Nonsense Inc · Middletown, DEN445BDornoch Services LLC · Dover, DEN445BGBowling Green Flight Center LLC · Bowling Green, OHN445BLBlue Line Aviation LLC · Smithfield, NCN445CACivil Air Patrol · Maxwell Afb, ALN445CPCivil Air Patrol · Maxwell Afb, ALN445DChristiansen Aviation LLC · Wilmington, DEN445DCWith Wings As Eagles Aviation LLC · Middletown, DEN445DHOhio University · Albany, OHN445HPChopra Family Lp · Tulare, CAN445HSBas Part Sales LLC · Greeley, CON445JSAg Ranch Services LLC · Lewistown, MTN445KCCramer Kirby · Fallbrook, CAN445KPHawaii Pacific Aviation Inc · Kailua Kona, HIN445KSPeraton Services LLC · Bozeman, MTN445MGGeorgia Aviation Authority · Eastman, GAN445MKNorth Star Aviation · Mankato, MNN445NDUnd Aerospace Foundation · Grand Forks, NDN445PWelsh Steven M · Oxford, NCN445PASkywest Leasing Inc · St George, UTN445RDensmore John L · Conway, WAN445RFRichards Jacob · Mount Olive, NCN445SPGasman401 Aviation LLC · Punta Gorda, FLN445WTClayton Edwin G · North Chesterfield, VAN445YSimmons Aviation Services LLC · Pawcatuck, CTN445ZAlpha Tango Aircraft LLC · Wilmington, DEN44604Lydic Daniel · Pittsburgh, PAN44605Luitjens Jacob J · Lagrange, GAN4460AHvizdak George D · Colliers, WVN4460S300 Dollar Burger LLC · Elmhurst, ILN4460TRuff Randall N · Bay City, MIN4460XStingray LLC · Pensacola, FLN4460YQuality Aviation Inc · Marana, AZN44614Swair LLC · Denver, CON4461744617 LLC · Post Falls, IDN44618Word Howard W Trustee · Kula, HIN4461AOrtwein Mathew M · Reedsport, ORN4461BGaylor Steven C Trustee · Ramona, CAN4461HJohnson Airspray Inc · Argyle, MNN4461JBoyd Eric L · Stuart, FLN4461TRobinson Joseph B · Washington, DCN4461VAimo Joseph Ray · Bountiful, UTN4461WKimball Douglas S · Bedford, INN4461XHaggerty James D · Scott Depot, WVN4461YRubbert Jan D · Upham, ND
Back to AD 2007-04-19 R1