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.
N425RJFant Aircraft Enterprises LLC · Houston, TXN428DRMaverick Air II LLC · Deer Park, WAN42NFCest La Vie LLC · Piedmont, OKN440GPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN44VPGable S Corp · West Linn, ORN450FVYellowdome LLC · Emigrant, MTN469SSDeez-Nuts LLC · Goodlettsville, TNN46HBSunshining Aviation LLC · Wilmington, DEN46RBaci LLC · Portland, ORN47EGWing And Rotor Transportation Holdings LLC · Morristown, NJN484FMV1vr LLC · Wilmington, DEN488MHSmyrna Ready Mix Concrete LLC · Nashville, TNN48CGCorning Inc · Corning, NYN48KZN48kz LLC · Long Beach, CAN493CFShamrock Air LLC · Baltimore, MDN499MHHollingshead Aviation Services LLC · Murfreesboro, TNN4BAMonte Carlo Associates LLC · Santa Ana, CAN4DFCds Equipment LLC · Cincinnati, OHN4SM4sm LLC · West Palm Beach, FLN4TTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN500BLBnb LLC · Wilmington, DEN500CFPool Plane LLC · Seattle, WAN500JJUltimate Human Aviation LLC · Coconut Grove, FLN500LY1380 Jets LLC · Pittsfield, MAN504PASmee Homes Inc · Porterville, CAN504STSdt Air Delaware LLC · Wilmington, DEN508MMMarklyn Jet Parts LLC · Dallas, TXFirst renewal noticeN50BLBnb LLC · Wilmington, DEN50FGRegenerative Sports Tissue Bank Inc · Lawrenceville, GAN50LBRegistered aircraftN50PCSpritle LLC · Chicago, ILN50SNFirst Quality Falcon LLC · Great Neck, NYN50YPVillages Equipment Co · Leesburg, FLN50YTInternational Aviation Technical Services Inc · Torrance, CAN510HWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN510MPPark Avenue Aircraft Trust LLC Trustee · Dover, DEN510RHHms Holdings LLC · Charlotte, NCN5123Tpi Aircraft Interiors LLC · New Bern, NCN512KSMcreynolds Aviation LLC · Dallas, TXN513HSRanch Stadium Equipment Leasing Inc · Dallas, TXN513SKHappy Skies LLC · Dover, DEN515MFAh Jag LLC · Atlanta, GAN516CJTotal Aviation Corp · Garden City, NYN516JAKings Aviation Corp · Garden City, NYN5190Bsc Horizon LLC · Saint Louis, MON521CLWerner Enterprises Inc · Omaha, NEN522EECenergistic LLC · Dallas, TXN522TLDodson International Parts Inc · Rantoul, KSN527PJas Air LLC · New Windsor, NYN527SRedleaf Management Company LLC · Miami, FL
Back to AD 2001-22-10