Skip to content

Registered aircraft · 17,027

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

N1674FPlane Nuts Aviation LLC · Livingston, LABuilt 1966 · S/N 17255069 N1676FBrunson Tim R · Gilmer, TXS/N 17255071 N16771Tintman Inc · Spokane, WAS/N 15066452 N1678FHorne William D II · Oxford, MSBuilt 1966 · S/N 17255073 N1679FCrawford Anthony B · Hampton Cove, ALBuilt 1966 · S/N 17255074 N1679QRegistration Pending · Fulton, MSRegistration pendingBuilt 1971 · S/N 15072979 N167BHHolliday Robert R · Andover, KSBuilt 1966 · S/N 17255345 N1680FBoyette Robert Wayne · Ashford, ALBuilt 1966 · S/N 17255075 N1680QHanke Kenneth O · Clio, SCBuilt 1971 · S/N 15072980 N1681FRegistered aircraftBuilt 1966 · S/N 17255076 N1682FBravo Zak Air LLC · Lake Wales, FLBuilt 1966 · S/N 17255077 N1684FRedmon Robert J · Gallatin, TNBuilt 1966 · S/N 17255079 N1685QMore Right Rudder LLC · Newnan, GABuilt 1971 · S/N 15072985 N1686FAdams Claude T Jr · Palmer, AKBuilt 1966 · S/N 17255081 N1686QJ3 Jets LLC · Bellaire, TXBuilt 1971 · S/N 15072986 N1687FTigerair 2020 LLC · Newark, DES/N 17255082 N1688FSkydive Spi LLC · South Padre Island, TXBuilt 1966 · S/N 17255083 N1689QDolphin Aviation Flyers LLC · Stuart, FLBuilt 1971 · S/N 15072989 N168AERobinson Kevin B · Texarkana, TXBuilt 1963 · S/N 18255158 N1690FN1690f LLC · Bluffton, INBuilt 1966 · S/N 17255085 N1690QAviation Visions · Fernandina Beach, FLBuilt 1971 · S/N 15072990 N1691FVess Joel W · Cherryville, NCBuilt 1966 · S/N 17255086 N1692FBeck Seth · Deer Lodge, MTS/N 17255087 N1695QJostad Leo D · Bottineau, NDFirst renewal noticeBuilt 1971 · S/N 15072995 N1698QHudson Gregory K · Deming, NMBuilt 1971 · S/N 15072998 N169AJNolan Davis Dds LLC · Juneau, AKBuilt 1969 · S/N 17257981 N169FLBlue Moon Holding Co LLC · Boca Raton, FLS/N 17700047 N169JABixby & Sons LLC · Vale, ORBuilt 1964 · S/N 18256004 N169JWPatterson Matthew D · Knoxville, TNBuilt 1968 · S/N 17700360 N169PGHarty Joshua · Strasburg, COS/N T210-0423 N16DBDivan Richard W · Wautoma, WIBuilt 1969 · S/N 17258618 N16HTAviation Specialties Unlimited Inc · Boise, IDBuilt 1964 · S/N 2060134 N16KFFournier Louis W · Fort Worth, TXBuilt 1965 · S/N 15061619 N16KNIgwt Holding LLC · Richardson, TXBuilt 1965 · S/N 17253986 N16SHDickinson James C · Haslet, TXBuilt 1972 · S/N 15073404 N16VVLaughlin R C Jr · Boerne, TXBuilt 1967 · S/N R1720058 N16WLLivingston Patricia R · Wasilla, AKS/N 17256545 N17001Shields David A · Saylorsburg, PAS/N 15073572 N17004Depietro Shelley Jo · Olympia, WABuilt 1972 · S/N 15073575 N17009Wight John I · Anchorage, AKBuilt 1972 · S/N 15073578 N1700QAtkinson Jonathan E · Chapmansboro, TNBuilt 1971 · S/N 15073000 N1701Rolston Charles W · Shoreview, MNBuilt 1964 · S/N 17252418 N17014Alcorn Paul W · Bay City, MIS/N 15073581 N17016Mika Brian D · Andover, MNBuilt 1972 · S/N 15073583 N17019Reed James W · Boulder City, NVBuilt 1976 · S/N 17702496 N17021Fletcher John Guy · Diamondhead, MSS/N 15073587 N1702QStrutzenberg Kent R · Manson, IABuilt 1971 · S/N 15073002 N17033Browning Brad T · Lake Park, MNBuilt 1972 · S/N 150-73594 N17039Davidson Luke H · Gilmer, TXS/N 15073597 N1703QTroutman Noah M · Owensboro, KYBuilt 1971 · S/N 15073003

Back to AD 72-03-03 R3