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.

N5044HCoogan Dennis P · Madison, WIBuilt 1975 · S/N 17265315 N5044RSouth Bay Flight Training Center · Carolina, PRBuilt 1974 · S/N 17263285 N5045HGrabofsky Livestock & Grain Inc · Hogeland, MTBuilt 1975 · S/N 17265316 N50462Weekley Clint · Manvel, TXBuilt 1974 · S/N 17264202 N5046AHappy Landings Aviation LLC · Maple, NCBuilt 1955 · S/N 28046 N50479Alvarez Randolph Clarence · Igiugig, AKBuilt 1974 · S/N 17264204 N5047AAeroslat4 LLC · Lewes, DEBuilt 1955 · S/N 28047 N50484Freudenthal Jack J · Medford, WIBuilt 1974 · S/N 17264205 N50485Wiedeman Douglas J · Springboro, OHBuilt 1974 · S/N 17264206 N5048RSandeep Sharma LLC · Oshkosh, WIBuilt 1974 · S/N 17263289 N5049RIndiana Paging Network Inc · La Porte, INBuilt 1974 · S/N 17263290 N504FAClow International Airport LLC · Bolingbrook, ILBuilt 2003 · S/N 172S9504 N504JJEdwards William A · Midland, GABuilt 1979 · S/N 17273419 N504MAEastern Kentucky University · Richmond, KYBuilt 1983 · S/N 17275917 N5050ACampbell Barry A · Rogersville, TNBuilt 1955 · S/N 28050 N5051RSkywarrior Flight Training LLC · Pensacola, FLBuilt 1974 · S/N 17263291 N50523Koch Allen William · Anchorage, AKBuilt 1974 · S/N 17264209 N5053AKing David · Frisco, COBuilt 1955 · S/N 28053 N50545Christiansen Aviation LLC · Wilmington, DEBuilt 2009 · S/N 172S10889 N5054AGrimmonpre Gary · Huntley, ILBuilt 1955 · S/N 28054 N5054HHutchins Charles L · Bayou Vista, TXBuilt 1975 · S/N 17265320 N5055AN5055a LLC · Clayton, GABuilt 1955 · S/N 28055 N5055HShaka Skies LLC · Kihei, HIBuilt 1975 · S/N 17265321 N5055RGreat Lakes Air Ventures LLC · Mason, MIBuilt 1974 · S/N 17263295 N5057ASoar Above Flight Solutions LLC · Englewood, TNBuilt 1955 · S/N 28057 N5057HAjf Enterprises LLC · Des Moines, IABuilt 1975 · S/N 17265322 N5057RHeise Roger H · Clayton, NYBuilt 1974 · S/N 17263296 N5058ABeiter John A · Cle Elum, WABuilt 1955 · S/N 28058 N50590Usaeroflight LLC · Greenville, SCBuilt 1974 · S/N 17264212 N5059ASmith Rickey A · Divernon, ILS/N 28059 N5059CLewis University · Romeoville, ILS/N 17281122 N505FNovotny Paul A · Elk River, MNBuilt 1964 · S/N 17251911 N505JJAero Davis LLC · Camden, DEBuilt 1958 · S/N 46086 N505LPWifa (Washington International Flight Academy) LLC · Gaithersburg, MDBuilt 2000 · S/N 172S8546 N5061ASmith Aviation LLC · Springer, OKS/N 28061 N5062RRichland County Finance Department · Columbia, SCBuilt 1974 · S/N 17263300 N5063HParsons William L · Harrogate, TNBuilt 1975 · S/N 17265324 N5064HFranklin Air Services LLC · New Orleans, LABuilt 1975 · S/N 17265325 N5066AThordarson Norman K · Friday Harbor, WABuilt 1955 · S/N 28066 N5066RBurke William M · Norwalk, CTBuilt 1974 · S/N 17263304 N5067ADaniels Tim · Unalakleet, AKBuilt 1955 · S/N 28067 N5067HSanders Flight Training Center Inc · Jasper, ALS/N 17265326 N5069ANusz Russell I · Hitchcock, OKBuilt 1953 · S/N 28069 N5069HNehring Curtis A · Goleta, CABuilt 1975 · S/N 17265327 N506EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2022 · S/N 172S12857 N506SPHenrie Aviation LLC · Fairfield, NJBuilt 2000 · S/N 172S8363 N5071AMccanles Mike E · Adrian, MOBuilt 1955 · S/N 28071 N5071HFosse David K · Carbondale, ILS/N 17265329 N5072AGibbs James P · Boerne, TXS/N 28026 N5072HRiebeling Eric Herbert · Reno, NVBuilt 1975 · S/N 17265330

Back to AD 90-06-03 R1