Skip to content

Registered aircraft · 20,683

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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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.

N2182YWilson John M · San Antonio, TXBuilt 1962 · S/N 17249682 N2183JMichael Nehring Inc · Mohall, NDBuilt 2004 · S/N 172S9631 N21840Erickson Arnold F · Devils Tower, WYBuilt 1974 · S/N 17264031 N21841Erlinger Ronald W · Wickenburg, AZBuilt 1974 · S/N 17264032 N2185EMckenzie Owen R Jr · Burlington, NCBuilt 1978 · S/N 17271182 N21878Lie Chris E · Kotzebue, AKBuilt 1974 · S/N 17264038 N21887Gilheany Robert V · Hicksville, NYBuilt 1974 · S/N 17264039 N21893Western Territory Flyers LLC · Fairfax, CABuilt 1974 · S/N 17264040 N218EABauer Todd A · Kenmare, NDBuilt 1970 · S/N 17259583 N218PPSumrell James E III · Bumpass, VABuilt 1976 · S/N 172-67520 N218RARozo Jhon B · Orlando, FLBuilt 1975 · S/N 17265450 N2191YDecker Ronnie L · Meno, OKBuilt 1962 · S/N 17249691 N21950Cousins Mark T · Portland, ORS/N 17264046 N21956Lake Elmo Flyers LLC · Vadnais Heights, MNBuilt 1974 · S/N 17264048 N2196YKoelbl Aviation LLC · Whitesboro, TXBuilt 1962 · S/N 17249696 N2197YWeber Raymond E · Palmer, AKBuilt 1962 · S/N 17249697 N2198YCustard Ray · Houston, TXBuilt 1962 · S/N 17249698 N219CACivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13080 N219SPLouisville Aircraft Leasing LLC · Louisville, KYBuilt 1999 · S/N 172S8219 N21ATMeadville Aero Club LLC · Erie, PABuilt 1977 · S/N 17268907 N21LFLunken Flight Training Center LLC · Cincinnati, OHBuilt 2001 · S/N 172S8936 N21LS7ac Aviation LLC · Fort Worth, TXBuilt 1964 · S/N 17251817 N21RPJ-Dawgs Aviation LLC · Greenville, NCS/N 17252591 N21SZVista Air Inc · Pacoima, CABuilt 1998 · S/N 17280653 N2202QLewis University · Romeoville, ILBuilt 2007 · S/N 172S10517 N22034Robertson David L · Ray, MIBuilt 1974 · S/N 17264052 N22055Adrian Ojeda Jr · San Ysidro, CAS/N 17280902 N2207ETeton Leasing LLC · Pocatello, IDBuilt 1978 · S/N 17271186 N2208Gibson Kevin T · Orange, VABuilt 1956 · S/N 29503 N22080Sale Reported · Las Vegas, NVSale reportedS/N 17264053 N2209EIngersoll George P · Lakewood, COBuilt 1978 · S/N 17271188 N220CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 172S13256 N220CPCivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13046 N220EPLeyva Jose Luis · New Smyrna Beach, FLBuilt 1985 · S/N 172-76484 N220JAHogan Field Hangars LLC · Fairfield, OHBuilt 1984 · S/N 172-76157 N220NYCa Aviation 172 LLC · Santa Barbara, CABuilt 1974 · S/N 17263763 N220WCJeffery & Weiss Holdings LLC · Long Beach, CAS/N 172S10519 N22101Propwash Aviation LLC · Midland, MIBuilt 1974 · S/N 17264055 N2212WCleveland Frank W · Quinhagak, AKBuilt 1978 · S/N 17271516 N2219ESorbi Aviation Inc · El Cajon, CABuilt 1978 · S/N 17271189 N221AGryczewski John · Olive Branch, MSBuilt 1956 · S/N 28413 N221DMRush Aviation LLC · Melrose, NMBuilt 1971 · S/N 17260155 N221EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2021 · S/N 172S12621 N221KLMather Don · Sandusky, OHBuilt 1973 · S/N 17261348 N221MEKarabin Gerald D · Vicksburg, MIBuilt 2000 · S/N 172S8481 N221MFWings Over Texas Holdings LLC · Denton, TXBuilt 1976 · S/N 17267380 N221NYFarukh Shroff · Pittston, PABuilt 1981 · S/N 17274978 N221SMMccain Stephen M · Columbia, MSBuilt 1976 · S/N 17267274 N221TJSafety In Motion Flight Center Inc · Puyallup, WABuilt 1978 · S/N 17271059 N22205Venaleck Joan · Concord Township, OHBuilt 1974 · S/N 17264058

Back to AD 90-06-03 R1