Skip to content

Registered aircraft · 3,848

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

N107ELAa-Aero LLC · Lewes, DEBuilt 2024 · S/N 172S13140 N1087CPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2006 · S/N 172S10268 N10897Edb Air Inc · Wilsonville, ORBuilt 2007 · S/N 172S10606 N1089DHeavy Metal Air LLC · Farmingdale, NYBuilt 2006 · S/N 172S10269 N108ED95 Msg/Svra Aero Club · Edwards Afb, CABuilt 2007 · S/N 172S10631 N108HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2002 · S/N 172S9049 N108PTHenrie Aviation LLC · Fairfield, NJBuilt 2005 · S/N 172S10089 N108TCAmeriflyers Of Texas Inc · Addison, TXBuilt 2001 · S/N 172S8801 N1090JRocky Mountain Flight Consultants LLC · Boulder, COFirst renewal noticeBuilt 2006 · S/N 172S10271 N1090VAviation Training LLC · Wilmington, DEBuilt 2006 · S/N 172S10283 N1090WMedary Aviation LLC · Brookings, SDBuilt 2006 · S/N 172S10284 N1092AGulf Coast Aviation LLC · New Orleans, LABuilt 2006 · S/N 172S10286 N1097NSale Reported · Peoria, AZSale reportedBuilt 2005 · S/N 172S9821 N1097YAtlas Aviation Tampa Inc · Tampa, FLBuilt 2006 · S/N 172S10296 N109LULynn University Inc · Boca Raton, FLBuilt 2001 · S/N 17280991 N109TJLanier Equipment Leasing LLC · Gainesville, GABuilt 2001 · S/N 17280985 N11019Cc Ventures LLC · Bowling Green, KYBuilt 2006 · S/N 172S10300 N11024Cao Wayne M · Dublin, CABuilt 2000 · S/N 17280913 N1104XFlight Training Aircraft LLC · Wilmington, DEBuilt 2006 · S/N 172S10297 N1107GLunken Flight Training Center LLC · Cincinnati, OHBuilt 2006 · S/N 172S10303 N110LULynn University Inc · Boca Raton, FLBuilt 2006 · S/N 17281326 N110SQLand Air & Sea LLC · Concord, NCBuilt 2006 · S/N 172S10384 N1120ZWhite Wing Air LLC · Garden Grove, CAS/N 172S10313 N1122TAircraft Solutions Group LLC · Englewood, COBuilt 2019 · S/N 172S12416 N1127DWings Over Texas Holdings LLC · Denton, TXBuilt 2006 · S/N 172S10247 N1129CLanier Equipment Leasing LLC · Gainesville, GABuilt 2018 · S/N 172S12227 N1129KOrange County Flight Center Inc · Santa Ana, CABuilt 2006 · S/N 172S10315 N112PFEastern Kentucky University · Richmond, KYBuilt 1998 · S/N 17280400 N112PZSkymaxx Inc · Daytona Beach, FLBuilt 2005 · S/N 172S9833 N112SVGb Aviation Of Alabama LLC · Millry, ALBuilt 2003 · S/N 172S9380 N1132WC Flying K Aviation LLC · Savery, WYFirst renewal noticeBuilt 2006 · S/N 172S10125 N1132XWest Coast Equipment Leasing LLC · Englewood, COBuilt 2006 · S/N 172S10316 N113AKFlight Training Aircraft LLC · Wilmington, DEBuilt 2006 · S/N 172S10182 N113PFPremier Flight Center LLC · Hartford, CTBuilt 1998 · S/N 17280401 N113SVChristiansen Aviation LLC · Wilmington, DEBuilt 2003 · S/N 172S9512 N114FBFly Appleton LLC · Appleton, WIBuilt 2005 · S/N 172S9811 N114VKKennedy Virgil C DBA · San Marcos, TXBuilt 2001 · S/N 172S8695 N1152ZRainier Flight Service LLC · Renton, WABuilt 2006 · S/N 172S10339 N1154GPlane Nonsense Inc · Middletown, DEBuilt 2006 · S/N 172S10126 N1154WAerosim Academy Inc · Sanford, FLBuilt 2007 · S/N 172S10608 N1157RSale Reported · Miami, FLSale reportedBuilt 1998 · S/N 17280627 N1158QN1158q LLC · Palm City, FLBuilt 2006 · S/N 172S10354 N1158VAtp Aircraft 7 LLC · Wilmington, DEBuilt 2006 · S/N 172S10355 N1159KCavu Aero LLC · Marietta, GABuilt 2006 · S/N 172S10357 N1159ZThunderfighter LLC · Englewood, COBuilt 2006 · S/N 172S10362 N115CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N 172S12330 N115FJFargo Jet Center LLC · Fargo, NDBuilt 2008 · S/N 172S10784 N115KSKent State University · Stow, OHBuilt 1999 · S/N 17280819 N115LWCrest Airpark Inc · Kent, WABuilt 2005 · S/N 172S9868 N115SV115sv LLC · Lamar, MOBuilt 2004 · S/N 172S9663

Back to AD 2012-22-01