AD 2001-22-10
Registered aircraft · 474
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:2001-22-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:2001-22-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:2001-22-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:2001-22-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.
N529SGM 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, FLN54YPPhifer Inc · Tuscaloosa, ALN550SHFalcon 55 LLC · West Bradenton, FLN550THAmc 50 LLC · Wilmington, DEN550WMWno Trust Services LLC Trustee · Wilmington, DEN551ADAci Partners LLC · Ewing Township, NJN555CKCarroll Aviation LLC · Wilmington, DEN556HDN50hd LLC · Salt Lake City, UTN55HSRapid Leasing Inc · Cedar Rapids, IAN571CBKba 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, NYN58HLGreen Button Holdings LLC · Overland Park, KSN590CLInternational Aviation LLC · Wheeling, ILN598WCWaste Connections US Inc · Houston, TXN59YPNextgen Flying LLC · The Villages, FLN5VJFalconagain Inc · New York, NYN600JBOgden Aviation LLC · Hinsdale, ILN600JMEast Lake Jet Aviation LLC · Montauk, NYN600LYMajjec Jhett LLC · Springfield, MAN601GS1 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, DEN649TTTownes Aircraft Sales LLC · Paris, TXN655TCTlc 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, CT
Back to AD 2001-22-10