AD 2001-01-05
Registered aircraft · 149
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-01-05')
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-01-05')
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-01-05') 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-01-05') 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.
N320GWSky Wheeels LLC · Prince Frederick, MDN325EXFalcon 325 LLC · Fort Pierce, FLN333KEFalconmitch Inc · Sulphur Springs, TXN346EXWebair LLC · Warrenton, VAN34TJAbove The Rest Aircraft Services LLC · Midlothian, TXN35CDCoastal Development Group LLC · Boca Grande, FLFirst renewal noticeN362PTN378c LLC · Parker, CON373RRM10 LLC · Rolling Meadows, ILN37WXCsc Delaware Trust Co Trustee · Wilmington, DEN383MCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN388BBPw Transport LLC · Lafayette, LAN395HEBillron LLC · Houston, TXN396JR396jr LLC · Macon, GAN401JWWatts John I · Murchison, TXN408CJDt Management Group LLC · Phoenix, AZN413VLFalcon Vl LLC · Wilmington, DEN42GEWatts John · Murchison, TXN454DPSkyview LLC · Wilmington, DEN463AKFlying Farmer LLC · Wilmington, DEN46MKSplendid Jet Lease LLC · Cape Coral, FLN500CFPool Plane LLC · Seattle, WAN500LY1380 Jets LLC · Pittsfield, MAN50BLBnb LLC · Wilmington, DEN50FGRegenerative Sports Tissue Bank Inc · Lawrenceville, GAN50PCSpritle LLC · Chicago, ILN50SNFirst Quality Falcon LLC · Great Neck, NYN50YPVillages Equipment Co · Leesburg, FLN50YTInternational Aviation Technical Services Inc · Torrance, CAN510MPPark Avenue Aircraft Trust LLC Trustee · Dover, DEN5123Tpi Aircraft Interiors LLC · New Bern, NCN513SKHappy Skies LLC · Dover, DEN516CJTotal Aviation Corp · Garden City, NYN522EECenergistic LLC · Dallas, TXN54DRGarcia David D · Midlothian, TXN54YPPhifer Inc · Tuscaloosa, ALN550WMWno Trust Services LLC Trustee · Wilmington, DEN556HDN50hd LLC · Salt Lake City, UTN55HSRapid Leasing Inc · Cedar Rapids, IAN58HLGreen Button Holdings LLC · Overland Park, KSN59YPNextgen Flying LLC · The Villages, FLN5CAMach 87 LLC · Sulphur Springs, TXN600JBOgden Aviation LLC · Hinsdale, ILN600LYMajjec Jhett LLC · Springfield, MAN606AMSl Jet LLC · Cleveland, TNN649TTTownes Aircraft Sales LLC · Paris, TXN653FJDwts LLC · Powder Springs, GAN655PEDunbar Aviation LLC · West Kingston, RIN67MTWindway Capital Corp · Sheboygan Falls, WIN680JSBank Of Utah Trustee · Salt Lake City, UTN68YBCzzc Aviation LLC · Tucson, AZ
Back to AD 2001-01-05