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.

N650VVMindy Limited LLC · Muscatine, IABuilt 1969 · S/N 17258561 N65107Renforth Michael E · Yorktown, VABuilt 1982 · S/N 17275686 N65112Jav Air Services LLC · Anchorage, AKS/N 17275688 N6511GBuerk James R · Smethport, PABuilt 1979 · S/N 17273603 N6511VSc Skywalker Aviation LLC · West Sacramento, CABuilt 1980 · S/N 172RG0741 N6512DCajun Wings LLC · Bourg, LABuilt 1979 · S/N 17272836 N6512HOrganization Of Black Aerospace Professionals Inc · Olive Branch, MSBuilt 1975 · S/N 17265471 N6512KLoomis Aviation LLC · Columbus, OHBuilt 1980 · S/N 17274206 N6513DGhia Flying Venture LLC · Scottsdale, AZBuilt 1979 · S/N 17272837 N6514JJuggernautaviation LLC · Lewes, DEBuilt 1980 · S/N 17273880 N65172Kfam Enterprises LLC · Dover, DES/N 17252998 N6517DSlaboszewski Donald W Jr · Joliet, ILS/N 17272839 N65180Mccraw Bryan · Telephone, TXBuilt 1982 · S/N 17275702 N65191Bampton Dennis · Portage Des Sioux, MOBuilt 1982 · S/N 17275705 N65192Tactical Integrated Training Solutions LLC · Colorado Springs, COBuilt 1982 · S/N 17275706 N65197Aviator Education LLC · Greeley, COBuilt 1972 · S/N 17275707 N6519JDms Defense LLC · Annapolis, MDBuilt 1980 · S/N 17273882 N651EREmbry-Riddle Aernautical University Inc · Prescott, AZBuilt 2023 · S/N 172S13085 N651MAPea-Wayman Flight LLC · Daytona Beach, FLBuilt 2000 · S/N 17280897 N651PASmn Investments Inc · Greeneville, TNBuilt 2017 · S/N 172S12016 N6521DWaade Odd · Bellingham, WABuilt 1979 · S/N 17272842 N65221Wings Over Texas Holdings LLC · Denton, TXBuilt 1982 · S/N 17275711 N6522RKnot Ventures LLC · Kalispell, MTBuilt 1979 · S/N 172RG0191 N6523DAir Shares LLC · Casper, WYBuilt 1979 · S/N 17272844 N6523VReal Jonathan D · Kamuela, HIBuilt 1980 · S/N 172RG0749 N6524DZuckerman Zvi A · Boardman, OHBuilt 1979 · S/N 17272845 N6524HCole Keith D Trustee · Celina, TXBuilt 1975 · S/N 17265474 N652515280 Flying Club LLC · Castle Pines, COBuilt 2004 · S/N 172S9690 N65259Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1982 · S/N 17275715 N6525DAerospace Testing Engineering & Certification Inc · Seattle, WABuilt 1979 · S/N 17272846 N6526VGoodrow Anthony F · Creede, COBuilt 1980 · S/N 172RG0752 N65275Registered aircraftBuilt 1982 · S/N 17275719 N65276Christiansen Aviation LLC · Wilmington, DEBuilt 1982 · S/N 17275720 N6527RAmerican Aviation LLC · Yuma, AZBuilt 1979 · S/N 172RG0196 N6528VFischer Heather A · Merrimack, NHBuilt 1980 · S/N 172RG0754 N65290So Cal Leasing LLC · El Cajon, CABuilt 2004 · S/N 172S9693 N65295Northwoods Air LLC · Orono, MEBuilt 1982 · S/N 17275723 N6529DG Force Advantage LLC · Lewes, DES/N 17272848 N6529VAhlhorn Travis Wayn · New Braunfels, TXBuilt 1980 · S/N 172RG0755 N652EPChristiansen Aviation LLC · Wilmington, DEBuilt 2016 · S/N 172S11691 N652MAAbove And Beyond Aviation LLC · Austin, TXBuilt 2000 · S/N 17280903 N652NDInternational Air Services Inc Trustee · Carson City, NVBuilt 2014 · S/N 172S11468 N652PASmn Investments Inc · Greeneville, TNBuilt 2017 · S/N 172S12017 N652RHTwohy David S · Osceola, WIBuilt 1976 · S/N 17266850 N652SPChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 172S8058 N6530HWagons West LLC · Myrtle Beach, SCBuilt 1975 · S/N 17265477 N6530RByers Travis M · Villa Rica, GABuilt 1979 · S/N 172RG0199 N65311Mustang Sally Aviation LLC · Camden, SCBuilt 2004 · S/N 172S9695 N6531RBruno Gennaro S · Lewes, DEBuilt 1979 · S/N 172RG0200 N65329Advanced Aviation Group LLC · Frederick, MDBuilt 2004 · S/N 172S9702

Back to AD 90-06-03 R1