AD 2001-03-06
Registered aircraft · 328
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-03-06')
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-03-06')
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-03-06') 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-03-06') 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.
N400PKN400pk Leasing LLC · Wichita, KSN400PVRk-263 Leasing LLC · Benton, KSN400RGN400rg Leasing LLC · Wichita, KSN400RYRegistered aircraftN400SMN400sm Leasing LLC · Wichita, KSN400TCMorning Star Aviation LLC · Indianapolis, INN400TUN400tu Leasing LLC · Wichita, KSN400UFNova Jets USA Corp · Orlando, FLN400VPN400vp LLC · Wilmington, DEN400WFTwo Rivers Aviation LLC · Wichita, KSN400XClemens Aviation LLC · Wichita, KSN400XAN400xa LLC · Wichita, KSN400XCN400xc Leasing LLC · Wichita, KSN400XPLdm Holdings Inc · Dansville, NYN400XRN400xr LLC · Wichita, KSN400ZZN400zz Leasing LLC · Wichita, KSN401BCNextant Sn 36 LLC · Boca Raton, FLN401RLGuardian Pharmacy LLC · Atlanta, GAN401XRBank Of Utah Trustee · Salt Lake City, UTN402FBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN402XTGuntrack Aviation LLC · Castle Rock, CON404BCRk276 LLC · Gary, INN404LRSkyknight LLC · Greeneville, TNN404MSAir 121 LLC · Jacksonville, FLN405MGKm Operations LLC · Alpharetta, GAN407CWCorporate Wings LLC · Richmond Heights, OHN407TCTjtwo LLC · Nashville, TNN408MLAem Air LLC · Coral Gables, FLN40DXAmericanus Transport LLC · Sunrise, FLN410LGGrove City Aviation LLC · Mercer, PAN412GJAlliance Aviation Group LLC · Wilmington, DEN412TSHxp LLC · Wilmington, DEN414HVKitty Hawk LLC Trustee · Fort Worth, TXN418CTMmu Aviation LLC · West Orange, NJN418GJAlliance Aviation Group LLC · Wilmington, DEN419TMRelentless2012 LLC · Tampa, FLN41CGN41cg Leasing LLC · Wichita, KSN424SKCentral Iowa Aviation LLC · Ankeny, IAN425BJDodson International Parts Inc · Rantoul, KSN428HPHighland Paving Co LLC · Eastover, NCN432MAFwj Aircraft LLC · Columbus, GAN436FLFlight Options LLC · Cleveland, OHN43BDMr3 Air LLC · Cincinnati, OHN440JRHilsinger Aviation LLC · Climax, NCN440LNBlue Horizon Point LLC · Lewes, DEN440TATeam Aero LLC · Shawnee, KSN440XTL C Whitford Co Inc · Wellsville, NYN442EAAziz Walid George Haddad · San Antonio, TXN442GJFirm Foundation Aviation LLC · Brea, CAN445VLChill Aviation LLC · Saint Petersburg, FL
Back to AD 2001-03-06