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.

N7110QLawson Virgil · Sylvar Grove, KSS/N 17260410 N7110TWright Donald E · Greensboro, NCS/N 46710 N7111ABurgess Fred P · Titusville, FLBuilt 1956 · S/N 29211 N7111NAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 1977 · S/N 17269101 N7111TMesseder Thomas Alan Jr · Fredericksburg, VABuilt 1959 · S/N 46711 N7112GHooper Walter E III · Spring City, TNBuilt 1969 · S/N 17258812 N7113ATrail Richard L · Mccook, NEBuilt 1956 · S/N 29213 N7113QMiles Michael G · Hillsborough, NCBuilt 1972 · S/N 17260413 N7114QSass Kenneth · Charlotte, NCBuilt 1972 · S/N 17260414 N7114TMeyer Andrew J · Carter, SDBuilt 1959 · S/N 46714 N7115ARothenbusch Michael G · Tampa, FLBuilt 1956 · S/N 29215 N7115QMaggart Kenneth R · Lutz, FLBuilt 1972 · S/N 17260415 N7115T172 Club LLC · Olalla, WABuilt 1959 · S/N 46715 N7116QStogner Sarah E · Monahans, TXBuilt 1972 · S/N 17260416 N7116TMaierhoffer Henry F · Sylvania, GAS/N 46716 N7117GBaker Brady B · South Hero, VTBuilt 1969 · S/N 17258817 N7117TOrtega Rolando J · Davie, FLBuilt 1959 · S/N 46717 N7118QMartin Stephen T · Green Cove Springs, FLBuilt 1972 · S/N 17260418 N7119AMcfarland Michael G · Seabeck, WABuilt 1956 · S/N 29219 N711GTRadcliff Charles · Las Vegas, NVBuilt 1969 · S/N 17258811 N711JSSterling Flight Training · Jacksonville, FLS/N 172S9682 N711NFSkywarrior Flight Training Inc · Pensacola, FLBuilt 1984 · S/N 17276196 N711SNSkywatch Aviation LLC · French Village, MOBuilt 1965 · S/N 17253928 N711UATuthill Andrew M · Etna, NHBuilt 1978 · S/N 17271695 N711WEMelbourne Flight Training LLC · Melbourne, FLS/N 17272616 N7120GSky Hook Inc · Red Wing, MNBuilt 1969 · S/N 17258820 N7120QClodfelter Terry Lynn · Norwood, NCBuilt 1972 · S/N 17260420 N7120TDelauder Patrick J · Terra Alta, WVBuilt 1959 · S/N 46720 N7121ARoberts Calvin D · Bluebell, UTBuilt 1956 · S/N 29221 N7121TSiscoe Ronald D · Bloomington, INBuilt 1959 · S/N 46721 N7122GBirmingham Flight Center LLC · Birmingham, ALBuilt 1969 · S/N 17258822 N7123AMerchant Herbert M · Powhatan, VAS/N 29223 N7123GJet & Rotor Aviation LLC · Sacramento, CABuilt 1969 · S/N 17258823 N7123TDevalcourt Randall · Washington, LABuilt 1959 · S/N 46723 N7124QVy Aviation LLC · Gentry, ARBuilt 1972 · S/N 17260424 N7124TCaskey Jessica B · Anchorage, AKS/N 46724 N7125GBohannan Joshua S · Rose Hill, KSFirst renewal noticeBuilt 1969 · S/N 17258825 N7125QPiedmont Flight Inc · Winston Salem, NCBuilt 1972 · S/N 17260425 N7126AFreeman Michael D · Morgantown, INBuilt 1956 · S/N 29226 N7127ASeremet Cristina L · Beaver Dam, WIS/N 29227 N7127TLehmer Jereme · Oxford, NYBuilt 1959 · S/N 46727 N7128AEgbert Tom · Claremore, OKBuilt 1956 · S/N 29228 N7128GDsr Cherokee 180 LLC · Dallas, TXBuilt 1969 · S/N 17258828 N7128QAmerican Patrols Inc · Midland, TXBuilt 1972 · S/N 17260428 N7129GSmith Lyle D · San Marcos, TXBuilt 1969 · S/N 17258829 N7129QG Alaouie LLC · Port Austin, MIBuilt 1972 · S/N 17260429 N712DAlpha Aviation LLC · Dalhart, TXBuilt 1976 · S/N 17268279 N712EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2022 · S/N 172S12882 N712LULiberty University School Of Aeronautics · Lynchburg, VABuilt 2015 · S/N 172S11659 N712NVEpic Aviation Enterprises LLC · Austin, TXBuilt 2005 · S/N 172S9960

Back to AD 90-06-03 R1