Skip to content

AD 2003-09-09 R1

Registered aircraft · 175

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

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:2003-09-09-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2003-09-09-R1') ORDER BY n_number

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:2003-09-09-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2003-09-09-R1')
  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:2003-09-09-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2003-09-09-R1')
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.

N441NDFlying Fish 441 LLC · Phoenix, AZBuilt 1979 · S/N 441-0123 N441NFTaylor Aviation Inc · Fort Benton, MTBuilt 1983 · S/N 441-0316 N441PMJtg Enterprises LLC · Mayfield, KYBuilt 1980 · S/N 441-0124 N441PNPioneer Nursery · Visalia, CABuilt 1985 · S/N 441-0347 N441PPLand Air Sea Inc · Chesapeake, VABuilt 1982 · S/N 441-0292 N441PWSophie Sullivan LLC · Hartland, MIBuilt 1981 · S/N 441-0240 N441RBruce The Flying Dog LLC · San Marcos, CABuilt 1984 · S/N 441-0343 N441SBCfc 441 LLC · Cicero, INBuilt 1982 · S/N 441-0301 N441SKN441sk LLC · Anchorage, AKBuilt 1980 · S/N 4410159 N441SMEssex Transport LLC · Canton, GABuilt 1980 · S/N 4410134 N441TDColumbia Asset Trust Corp Owner Trustee · Wichita, KSBuilt 1980 · S/N 441-0170 N441TFTime Flies LLC · Grand Junction, COS/N 441-0032 N441TGDodson International Parts Inc · Rantoul, KSBuilt 1981 · S/N 441-0200 N441TLSky High Blue LLC · Orlando, FLBuilt 1986 · S/N 441-0357 N441TNPure Aviation Leasing LLC · Las Vegas, NVBuilt 1979 · S/N 4410085 N441UCConquest Associates LLC · Concord, MAS/N 4410344 N441VTraveling Alana Inc · Key Largo, FLBuilt 1983 · S/N 4410322 N441VHWe Fly LLC · Fort Payne, ALBuilt 1981 · S/N 441-0225 N441VMVitality Aviation LLC · Aitkin, MNS/N 441-0361 N441WDJv Air LLC · Charlotte, VTBuilt 1979 · S/N 441-0107 N441WFRaber Flight Services LLC · Littleton, COS/N 4410115 N441WJCocoamo LLC · Merritt Island, FLS/N 441-0194 N441WLVichy Enterprises LLC · Wilmington, DEBuilt 1978 · S/N 441-0041 N441WTHaven Air LLC · Winter Garden, FLBuilt 1983 · S/N 441-0313 N441XMatosich Andrew J · Bigfork, MTS/N 441-0254 N444AKWareing Flight Services LLC · Sturgis, SDBuilt 1984 · S/N 441-0334 N454EAGeo G2 Solutions Inc · Moffett Field, CAS/N 4410054 N456GTConquest 294 LLC · Wilmington, DEBuilt 1982 · S/N 441-0294 N466SMMiddleton Lee Sam · Lubbock, TXBuilt 1982 · S/N 441-0300 N477BJrs Aviation LLC · Falls City, NES/N 441-0055 N500ERConquest II LLC · Kenner, LABuilt 1979 · S/N 441-0084 N502BRUS Leasing And Financial Inc · Wilmington, DEBuilt 1980 · S/N 4410135 N517NCConquest 441-0355 Inc Trustee · Wilmington, DEBuilt 1985 · S/N 4410355 N5411JTdm Aviation LLC · Huntsville, ALBuilt 1980 · S/N 441-0192 N552DLSky West Aviation Inc Trustee · Albuquerque, NMS/N 4410157 N553AMUnderwood Chris · Beverly Hills, FLBuilt 1981 · S/N 441-0219 N599ASTtc Aircraft Leasing Inc · Celina, TXBuilt 1980 · S/N 441-0183 N59RTBank Of Utah Trustee · Salt Lake City, UTBuilt 1980 · S/N 4410111 N626KBMoses International Inc · Bellevue, MIBuilt 1980 · S/N 441-0143 N6840TJkak Services LLC · Sheridan, WYBuilt 1982 · S/N 441-0299 N6851XUpper Peninsula Aviation LLC · Kingsford, MIBuilt 1981 · S/N 441-0212 N68HSBlackdog Air LLC · Wilmington, DES/N 441-0331 N711MBBarrick Gold Of North America Inc · Henderson, NVBuilt 1979 · S/N 441-0116 N716CCRichmond Wheeler LLC · Marshfield, WIBuilt 1981 · S/N 441-0213 N716SMConquest Flight LLC · Pottstown, PABuilt 1977 · S/N 441-0004 N725SVTtc Aircraft Leasing Inc · Decatur, TXBuilt 1978 · S/N 441-0051 N758RFSck Express LLC · Englewood, COBuilt 1978 · S/N 441-0012 N779CCRyan Robert M · Anaheim, CABuilt 1980 · S/N 4410155 N782YLLift And Thrust LLC · Chicago, ILS/N 441-0339 N784RRInarayan Aviation LLC · Orlando, FLBuilt 1979 · S/N 441-0078

Back to AD 2003-09-09 R1