AD 2002-15-06
Registered aircraft · 687
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-15-06')
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-15-06')
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-15-06') 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-15-06') 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.
N619LAArg Aviation LLC · Lexa, ARN619PFDel Ag Aero LLC · Milton, DEN62370Bell Flying Inc · Newport, ARN623BFHiggins Leasing Inc · The Woodlands, TXN624BFBrb LLC · Lewes, DEN625BFBrb LLC · Lewes, DEN62764Bell Flying Inc · Newport, ARN627LANew Frontier Aviation LLC · Fort Benton, MTN628FAAkbj LLC · Lewes, DEN629JPLj Leasing LLC · Cardington, OHN639LAJ & R Flying Service LLC · Alicia, ARN63AWAmerican Ag Aviation Inc · Five Points, CAN641SMRiverside Air LLC · Shelby, MSN661MAAramco Capital Company LLC · DhahranN662MAAramco Capital Company LLC · DhahranN663MAAramco Capital Company LLC · DhahranN665UHartley Flying Service Inc · Stuttgart, ARN670BFBrb LLC · Lewes, DEN670RBOver The Top Aviation Inc · Jonesboro, ARN672LAGarrett Flying Service Inc · Danbury, TXN674LAFerriday Flying Service Inc · Ferriday, LAN67AGA & L Farm Services Inc · Helena, ARFirst renewal noticeN684LARegistered aircraftN687LA5g'S Aviation LLC · Trumann, ARN69FYTexoma Ag LLC · Corsica, SDN69VCPro Agri Spraying Service Inc · Ropesville, TXN703NAMcelwain Russell · Lancaster, KSN711FUNeal Aircraft Inc · Slaton, TXN711NACkw Aviation LLC · Dalhart, TXN716FAFarm Air Corp · Minturn, ARN717DAAero Spray Inc DBA · Appleton, MNN718MLRice Flying LLC · Poplar Bluff, MON71BMEvergreen Flying Service Inc · Dover, DEN71HKSak IV LLC · Brookings, SDN721LAAir Repair Inc · Cleveland, MSN726RLLassco LLC · Middletown, DEN729CFWells Flying Services LLC · Holdrege, NEN729LARice Flying LLC · Corning, ARN729PFRtc Aviation LLC · Munday, TXN731TJDcs Air LLC · Lewes, DEN740LALissie Flying Service Inc · Lissie, TXN745LAKlein Flying Service Inc · Lawrenceville, ILN746LAAnderson Farming Co · East Bernard, TXN750LAWestwind Air LLC · Lake Village, ARN753FAFarm Air Corp · Hoxie, ARN754LAC & L Holzwarth Inc · Virden, ILN758LALowry Flying Service Inc · Grinnell, IAN767WPWestern Pilot Services Inc · League City, TXN7742LBcm Flying Inc · Shelby, MSN776ASBank Of Utah Trustee · Salt Lake City, UT
Back to AD 2002-15-06