AD 2002-23-20
Registered aircraft · 384
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-23-20')
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-23-20')
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-23-20') 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-23-20') 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.
N696JMFalcon Aviation Services LLC · Dallas, TXN699BGWord Of Life Christian Center Inc · Darrow, LAFirst renewal noticeN700FLFl Aircraft LLC · North Little Rock, ARN700PGAviation Xx LLC · Wilmington, DEN700SWSafeway Leasing Inc · Westmont, ILN70BRRegistered aircraftN70FKChildress Klein Management Services LLC · Charlotte, NCN70LFWind Turbine And Energy Cables Corp · Hasbrouck Heights, NJN70TTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN711FJBirner Aviation LLC · Earth City, MON711RWAuto & Otolar LLC · Lawrence, KSN711TJCenturion Investments Inc DBA · Chesterfield, MON711TQGrey Falcon LLC · Ewing, NJN711WHKcm Ventures Whitefish 2 LLC · Arlington, TXN711WVRoss Airplane LLC · Parkersburg, WVN716BHM Hixson Aviation LLC · Lake Dallas, TXN716GTS5 Aviation LLC · Longview, TXN717LAAdcnt Management Co LLC · Dallas, TXN719SHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN720MLNorthwestern Mutual Life Insurance Co · Milwaukee, WIN721FHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN72PSCool Grove Equipment LLC · Fort Lauderdale, FLN746ARJdm Aircraft LLC · Arlington, TXN754JLNewport Blue LLC · Corona Del Mar, CAN754MMKings Aviation Corp · Garden City, NYN75ABRivers Equipment III LLC · Nashville, TNN75KETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN7600PSas Institute Inc · Cary, NCN7600SSas Institute Inc · Cary, NCN763UGray & Company Inc · Metairie, LAN767WBScandere LLC · Waukesha, WIN76FDGrindstone Aviation LLC · New Castle, DEN775GMGlobus Aviation LLC · Audubon, PAN777XYCair Leasing LLC · Wilmington, DEN780SPScashley Falcon LLC · Los Angeles, CAN782RP399 Air LLC · Fort Lauderdale, FLN7883KRegistered aircraftN78CYWkc Corp · Saint Louis, MON790LTGbl LLC · Woodbury, MNN790TN16fx Trust · Wilmington, DEN79LE206 Holdings LLC · New Orleans, LAN7BD757bd LLC · Albuquerque, NMN7KCFalcon 200 Inc · Nashville, TNN800DWJfm Air II LLC · Wilton Manors, FLN800KMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN805ALScashley Falcon LLC · Portland, MEN808SFTgs Logistics LLC · Dover, DEN812PMEl Jefe Express II LLC · Lake Forest, ILN818THWilmington Trust Co Trustee · Wilmington, DEN81HMIheart Media Management Services Inc · New York, NY
Back to AD 2002-23-20