AD 2002-19-10
Registered aircraft · 1,092
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-19-10')
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-19-10')
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-19-10') 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-19-10') 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.
N4217WAviation Flying Service · Greenwood, MSN4219MBombero Aviation LLC · Childress, TXN4219WEverett Flying Service Inc · Holly Grove, ARN4219YTri State Aerial LLC · Canton, SDN4221STri Rotor Spray & Chemical · Ulysses, KSN422JCChorman Spraying LLC · Milton, DEN422RDAir-Sprayers Inc · Two Buttes, CON422TWSug-Air LLC · Lubbock, TXN4244FOli Grow LLC · Baskin, LAN4244PPrairie Ag Service LLC · Des Arc, ARN4247UHiggins Leasing Inc · Woodlands, TXN424FSOver And Under Flying Service Inc · Knox, INN42505Holloway Air Service Inc · Merigold, MSN42590Twin County Air-Ag Inc · Winnie, TXN4265DVisser Ag Inc · Rigby, IDN426LAC And C Flying Service Inc · Pocahontas, ARN427AAAero Leasing LLC · Virden, ILN427NSVisser Ag Inc · Rigby, IDN428JJKingrey William S · Richmond, TXN428LAFletcher Flying Service Inc · Roe, ARN42EAEscott Aerial Spraying LLC · El Reno, OKN437VADelta Air Inc · Belzoni, MSN438LADownstown Airport Inc · Vineland, NJN442MAMeyers Air Service LLC · Superior, NEN445HAAir Tractor Inc · Olney, TXN448LAAir Kraft Spraying Inc · Timber Lake, SDN45123Wood Flying Inc · Panhandle, TXN4512JCentral Iowa Agricultural Aviation LLC · Wellsburg, IAN4515JLowry Flying Service Inc · Grinnell, IAN45196Boettcher Aerial Inc · Beloit, KSN4523LWiebe Albert · Seminole, TXN4527XSug-Air LLC · Lubbock, TXN4528LSkyworks Aviation LLC · Waynesboro, GAN4532FWoodley Aerial Leasing LLC · Walnut, ILN45363South Delta Aviation Inc · West Helena, ARN4540FWoodley Aerial Leasing LLC · Walnut, ILN4541SKankakee Valley Aviation LLC · Wanatah, INN45469Over & Under Flying Service Inc · Madison, INN45472Rtc Aviation LLC · Munday, TXN4552TMci Leasing LLC · Decatur, ILN45553Racer Aviation LLC · Moorestown, NJN4555YDevil Dusters Inc · Artesia, NMN4556UAir Care Leasing LLC · Lamar, CON455PAMcginty Flying Service LLC · Jones, LAN455RANorrland Partners LLC · Hillsboro, NDN4567SBoyle Flying Service Inc · Boyle, MSN456LAJaj Flying LLC · Sutton, NEN457ATAeronautical Technologies Inc · Clovis, NMN458RANorrland Partners LLC · Hillsboro, NDN459RASilver Wings Flying Company LLC · Littlerock, WA
Back to AD 2002-19-10