AD 2002-11-03
Registered aircraft · 502
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:2002-11-03')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-11-03')
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:2002-11-03') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-11-03') 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.
N4515AB&R Aerial Crop Care Inc · Connell, WAN4525QAg Flyers Inc · Torrington, WYN45313Registration Pending · Southampton, NJRegistration pendingN4536QHoppe Air LLC · Beaman, IAN4537XPontiac Flying LLC · Pontiac, ILN4540YTlc Flying Inc · Colfax, WAN45461Shannon Agricultural Flying Inc · Clarksdale, MSN45506Mid Continent Aircraft Corp · Hayti, MON4550NNewberg Sky Spray LLC · Hector, MNN4551MCady Leslie L · Rock Falls, ILN477LACarlson Production Services LLC · Norcross, MNN479LARedline Aviation Lnc · Sioux City, IAN486FAA+ Aviation Services LLC · Garden City, KSN497JBNeal Aircraft Inc · Slaton, TXN5001LAcme Aerial Application LLC · Seneca Falls, NYN5002JBcs Aerial LLC · Butler, MON5003CCrop Air LLC · Eaton, CON5004VTim Whitfield Aviation Inc · Fairfield, NCN5007GWesterlin Harrington Flying Service Inc · Holdrege, NEN5009SBrignac Flying Service LLC · Columbus, MSN5010JGc Aviation LLC · Kalispell, MTN5012CVan Namen Jonathan E · Benoit, MSN5013CAir Tractor Inc · Olney, TXN5018JRegistration Pending · Littlefield, TXRegistration pending, pending cancellationN5019AReabe Spraying Service Inc · Plover, WIN501MHBeta Ag Inc · Ralls, TXN5022CCleveland Air Service Inc · Cleveland, MSN5022SSchneider Ag Inc · Rugby, NDN502ADReabe Spraying Service Inc · Plover, WIN502AGBank Of Utah Trustee · Salt Lake City, UTN502AMScott Precision Aerial LLC · Oberlin, KSN502ARAir Care Leasing LLC · Lamar, CON502BACrop-Serv Inc · Meade, KSN502BBStott Aerial Spray Inc · Jefferson, IAN502BMPrecision Ag Air LLC · Lake Village, ARN502BTRainey Aerial Ag Service Inc · Obion, TNN502CKPot Hook Leasing LLC · San Benito, TXN502CMWheels Down LLC · Buffalo Center, IAN502CPMcelwain Russell · Lancaster, KSN502DBDbl LLC · Hays, KSN502DEDavis Levi · Gratiot, WIN502DLCkw Aviation LLC · Dalhart, TXN502DSAir Dusters Inc · Roggen, CON502EMDeby Ag Leasing Lp · Wakarusa, INN502FATaylors Flying Service Inc · Utica, MSN502FDBank Of Utah Trustee · Salt Lake City, UTN502FFHeiderscheidt Aerial LLC · Sleepy Eye, MNN502GDBrett'S Spray Service Inc · Onida, SDN502GKMeyer Aviation Inc · Whittemore, IAN502HABlackhawk Air LLC · La Porte City, IA
Back to AD 2002-11-03