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.
N368CMKraemer Jeffrey J · Cold Spring, MNN368CPWilliams Truman V · Robbinsville, NCN368ESMindy Limited LLC · Muscatine, IAN368FSFrederick Investment Corp · Fort Lauderdale, FLN368HPHigh Performance Aircraft Inc · El Cajon, CAN368HYEngler Eric DBA · Cass City, MIN368JEJones Enterprises · Nacogdoches, TXN368JHUrsine L Attitudes Ltd · Richland, WAN368MState Of Montana · Helena, MTN368MEWbl Air LLC · Minneapolis, MNN368MKNorth Star Aviation Inc · Mankato, MNN368MSSilvestri Mark J · Warwick, NYN368POfferaire Inc · Lebanon, NJN368RTBaldhill Flying Partners Llp · Binford, NDN368SAIrish Sidney D · Roosevelt, NYN368TMStriker LLC · Lewes, DEN368VKranz Daniel · Hastings, MNN368ZAlpha Tango Aircraft LLC · Wilmington, DEN36900Bas Part Sales LLC · Greeley, CON36908Williams D Eric · Palm Springs, FLN3690AJohnson Mandley O Jr · Bismarck, NDN3690DR B M Corporation · Cropwell, ALN3690KCrouch James Doyle Jr Trustee · Germantown, TNN3690NDetraglia Michael C · Canandaigua, NYN3690REagle Aero LLC · Clermont, FLN36911Hyannis Air Service Inc · Hyannis, MAN3691AClark Clyde E · Naknek, AKN3691NGalvan Peter R · Slidell, LAN3691QKempf David V · San Tan Valley, AZN3691YHunt Lynn C Trustee · Windsor, CAN3691ZRiedesel Ralph L · Paton, IAN3692ABva Bonanza LLC · Keizer, ORN3692CDevil Dusters Inc · Artesia, NMN3692UPineview Ac Sales LLC · Bedford, WYN3692WMckimson Lance D · Wasilla, AKN3692ZRegistered aircraftN36939Holtzen Farms Inc · Jerome, IDN3693AC And F Enterprise L L C · Milford, MIN3693RA Parrottes View In Flight LLC · Wilmington, DEN3694LRegistered aircraftN3694NWheeler Kevin J · Concord, CAN3694RSippel Paula M · Webster, NYN3694UPara Tactics LLC · Shelton, WAFirst renewal noticeN3694YScott Dale D · Alliance, OHN36958N36zz LLC · Parkland, FLN3695ADehart T James Trustee · Kalama, WAN3695COrton Dennis · Mead, CON3695LBg Aviation LLC · Waukesha, WIN3695MTreanor James J · Wolcott, CTN3695NWalton Jerry Prince Jr · Monticello, FL
Back to AD 2007-04-19 R1