AD 2002-13-07
Registered aircraft · 824
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-13-07')
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-13-07')
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-13-07') 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-13-07') 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.
N520TCDodson International Parts Inc · Rantoul, KSN521CLWerner Enterprises Inc · Omaha, NEN521FLIfl Group Inc · Waterford, MIN526DJMs Falcon LLC · East Spring Valley, NYN527DAJory Aviation LLC · Edina, MNN527PJas Air LLC · New Windsor, NYN529KGCapstone Management LLC · Manchester, NHN529SGM G S Aviation Inc · Miami, FLN531JDRonin Tori Leasing LLC · Bloomfield Hills, MIN5379FN5379f LLC · Canton, OHN539CAResmed Inc · San Diego, CAN53FJTvpx Ars Inc Trustee · North Salt Lake, UTN53LTVpc Aviation LLC · Valencia, CAN53NJLear 100kz LLC · Burnet, TXN541FBank Of Utah Trustee · Salt Lake City, UTN541ZBank Of Utah Trustee · Salt Lake City, UTN542TPLakeridge Holdings LLC · Portland, ORN54DRGarcia David D · Midlothian, TXN54HGFifth Avenue Aviation LLC · Naples, FLN54MHTvpx Msn 390 Business Trust · North Salt Lake, UTN54YRPhifer Inc · Tuscaloosa, ALN550SHFalcon 55 LLC · West Bradenton, FLN550THAmc 50 LLC · Wilmington, DEN551ADAci Partners LLC · Ewing Township, NJN552GRGrp Aviation LLC · Van Nuys, CAN553GRRivers Edge Equipment Leasing LLC · Springfield, ILN555CKCarroll Aviation LLC · Wilmington, DEN555GSInvestjet LLC · Miami, FLN555HGShort Hills Aviators LLC · Morristown, NJN555MKNgl Aviation Tul LLC · Tulsa, OKN5567AAlliance Air Parts Acquisitions Corp · Oklahoma City, OKN556KMFifty-One Air LLC · Lampasas, TXN558RCovenanter Investments II LLC · Nashville, TNN560USTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN570DWarbler I LLC · Freeland, MIN575JJTm Aircraft Leasing LLC · Wilmington, DEN575TCTroy Equipment Holdings LLC · Houston, TXN577QTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN57KTKlein Tools Inc · Lincolnshire, ILN581STOakwood Books Inc · Charlottesville, VAN584VWilmington Trust Co Trustee · Wilmington, DEN588HPRbg Operations II LLC · Wilmington, DEN58CGCorning Inc · Corning, NYN58MWNextera Energy Equipment Leasing LLC · West Palm Beach, FLN590CLInternational Aviation LLC · Wheeling, ILN595PDirect Ventures Management LLC · Knoxville, TNN598WCWaste Connections US Inc · Houston, TXN599GJLham3 LLC · Plainfield, INN599PCBank Of Utah Trustee · Salt Lake City, UTN5CAMach 87 LLC · Sulphur Springs, TX
Back to AD 2002-13-07