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.
N5190Bsc Horizon LLC · Saint Louis, MON521CLWerner Enterprises Inc · Omaha, NEN522TLDodson International Parts Inc · Rantoul, KSN527PJas Air LLC · New Windsor, NYN527SRedleaf Management Company LLC · Miami, FLN529SGM G S Aviation Inc · Miami, FLN539CAResmed Inc · San Diego, CAN53FJTvpx Ars Inc Trustee · North Salt Lake, UTN544CMFalcon Fawzi III LLC · Fort Lauderdale, FLN54HGFifth Avenue Aviation LLC · Naples, FLN550SHFalcon 55 LLC · West Bradenton, FLN550THAmc 50 LLC · Wilmington, DEN551ADAci Partners LLC · Ewing Township, NJN555CKCarroll Aviation LLC · Wilmington, DEN571CBKba Bridges & Shields LLC · East Point, GAN575JJTm Aircraft Leasing LLC · Wilmington, DEN577QTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN57KTKlein Tools Inc · Lincolnshire, ILN581STOakwood Books Inc · Charlottesville, VAN588HPRbg Operations II LLC · Wilmington, DEN58CGCorning Inc · Corning, NYN590CLInternational Aviation LLC · Wheeling, ILN598WCWaste Connections US Inc · Houston, TXN5VJFalconagain Inc · New York, NYN600JMEast Lake Jet Aviation LLC · Montauk, NYN601GS1 Trophy Husband LLC · Omaha, NEN609CQFalki LLC · Winter Springs, FLN610RLFalconrl LLC · Missoula, MTN611TXMegaequipment LLC · Wilmington, NCN613BHBoz Holdings LLC · St Thomas, VIN615FJMegatel Group Services LLC · Dallas, TXN615MSMss Falcon 900 LLC · Denver, CON617DVCae III Ltd · Wilmington, DEN620DXAdams Aviation Services Inc Trustee · Wilmington, DEN622WMCsc Delaware Trust Co Trustee · Wilmington, DEN626AWHfl Aviation LLC · Dallas, TXN627CRArrowhead Aviation Inc · Batesville, ARN62NWE7 Alpha LLC · Austin, TXN636SJHrm Aviation LLC · Chesterfield, MON63JPZap Magic LLC · New Castle, DEN655TCTlc Aircraft Leasing LLC · Vero Beach, FLN661MSLone Star Avalanche LLC · Marble Falls, TXN667HFBd Plane Inc · Chicago, ILN66FJAlpha Mike Aviation LLC · Murfreesboro, TNN670JDAmber Services Inc · Chicago, ILN672WVWrbc Transportation Inc · Greenwich, CTN673HBSigma Equity LLC · San Francisco, CAN675AZJetco LLC · Kalamazoo, MIN67ELWard Ohara Companies LLC · Kansas City, MON687HA687 Holdings LLC · Newark, DE
Back to AD 2002-23-20