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.
N443JBGuy Jeffrey · Centerburg, OHN443JGRose Benjamin A · Newberg, ORN443KCRommel Kurt E · Clermont, FLN443KSKent State University · Stow, OHN443LCBlack Beauty Helicopters LLC · Davie, FLN443LTValiair Ltd Co Trustee · Casper, WYN443MGGeorgia Aviation Authority · Eastman, GAFirst renewal noticeN443MKNorth Star Aviation · Mankato, MNN443MMEarlybird Aerial Services LLC · Goodfield, ILN443MWKarren Kade R · Mountain Home, IDN443PFrederick Investment Corp · Raleigh, NCN443PABird Acquisition LLC · Phoenix, AZN443PKRegistration Pending · Kalispell, MTRegistration pendingN443RSalinas Construction Technologies Ltd · Pleasanton, TXN443RLGuinn Timothy J · Jennings, LAN443RPRichard E Pierson Construction Co · Pilesgrove, NJN443RSNtss LLC · Las Vegas, NVN443RVHansen Eric B · Freeland, WAN443SANovember Alpha LLC · Los Angeles, CAN443TTGudsteinn Thor Thordarson · La Porte, INN44400Vonditsianou Michalis · Milpitas, CAN44407Kroneck Timothy S · Plymouth, WIN4440BHaustrom Curtis R · Barnesville, OHN4440KKate & Jennifer Airlines LLC · Tampa, FLN4440LHutchison John · Big Lake, AKN4440PApac LLC · Berlin, NJN4440RLa Baronesa LLC · Fort Worth, TXN4440YMayes Brett R · Williams, CAN4440ZThompson Logan T · Alliance, NEN44411Ruiz Raul · Sugar Land, TXN44412J Mar Corp · Pittsburgh, PAN44413Premier Capital Enterprises LLC · Hurricane, UTN44416Registration Pending · Punta Gorda, FLRegistration pendingN4441JPinkston Lance C · Batesville, ARN4441QHaring Clay DBA · Lincoln, KSN4441RAtwood Flying Club · Atwood, KSN4441WHodge Henry D Jr · Anchorage, AKN4441ZThoft Matthew M · Wasilla, AKN44420England James M · West Paducah, KYN44421Rojas Alissa · Warwick, RIN44426Skyborne Airline Academy Inc · Vero Beach, FLN44429Bettencourt David A · Dayville, CTN4442AVella La Cava Air LLC · Albuquerque, NMN4442XHayes Kevin R · Richmond Hill, GAN4442ZKrutzfeldt John · Powderville, MTFirst renewal noticeN44430Red Eye Aviation LLC · Minocqua, WIN44431Cushman Nicholas R · Mesa, AZN4443AVollman Merlin · Pearland, TXN4443FGood Winds LLC · Waterville, MEN4443KClarke Richard W · Royal Oak, MD
Back to AD 2007-04-19 R1