Skip to content

Registered aircraft · 1,578

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:72-14-08-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:72-14-08-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:72-14-08-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:72-14-08-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:72-14-08-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:72-14-08-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.

N46CGGlobal Building Investments Inc · Scottsdale, AZS/N 310P0146 N46RKAir Positive LLC · Selbyville, DEBuilt 1969 · S/N 310P0122 N473SLuginbuhl Wayne E · Ormond Beach, FLBuilt 1966 · S/N 310K0131 N477MGJuliet Delta Aviation LLC · Bozeman, MTBuilt 1973 · S/N 421B0477 N47BGVonweisenstein Thomas W · Brentwood, TNBuilt 1974 · S/N 310Q1061 N47DSHalls Dave · Lilburn, GABuilt 1959 · S/N 39005 N47NFAndrews University · Berrien Springs, MIS/N 60-6047 N47RWSale Reported · Glen Allen, VASale reportedS/N 35088 N4800B310 LLC · Auburn, WABuilt 1955 · S/N 35100 N480BWAttitude Aviators Inc · North Myrtle Beach, SCBuilt 1967 · S/N 310L-0137 N4811BLifland Kenneth D · Mckinney, TXBuilt 1955 · S/N 35111 N4815BCochise Community College · Douglas, AZBuilt 1955 · S/N 35115 N4844BPrevost Christopher D · Sonoma, CAS/N 35144 N4863BBeach Travis W · Bishop, CABuilt 1955 · S/N 35163 N4877BHardman Kyle B · Shady Shores, TXBuilt 1955 · S/N 35177 N4884BPrevost Christopher · Sonoma, CABuilt 1955 · S/N 35184 N488SPSugarpop Air LLC · Chicago, ILBuilt 1967 · S/N 310N-0029 N4891BLiberty School Of Aviation Inc · Miami, FLRevoked, canceledBuilt 1955 · S/N 35191 N48BPRossman Richard J DBA · Glenview, ILBuilt 1975 · S/N 421B0957 N494WKingsbury Raymond S · Farmington, MNS/N 310K0103 N497JMBazzi Aviation LLC · Newark, DEBuilt 1972 · S/N 310Q0497 N499WWLakes Air LLC · Fargo, NDBuilt 1966 · S/N 411-0161 N49ARMoore Thomas A · Kennewick, WAS/N 421B0563 N4ADValiair Lc Trustee · Casper, WYBuilt 1973 · S/N 421B0467 N4AFN4af LLC · Conroe, TXBuilt 1968 · S/N 421-0142 N4AS310 Air Ltd · Seville, OHBuilt 1964 · S/N 310I0094 N4MUBlusky Properties & Investments LLC · Cameron, MOBuilt 1970 · S/N 421B0054 N4PJAnderson Richmond E Jr · Orlando, FLBuilt 1972 · S/N 310Q-0515 N5009QWeed Ryan W · San Francisco, CABuilt 1968 · S/N 310N-0109 N500QBAnderson Dana R · Redding, CABuilt 1958 · S/N 35760 N500RFJones Anthony Blake · Sylacauga, ALBuilt 1968 · S/N 310P0026 N500SHMergili Joseph P · El Paso, TXBuilt 1968 · S/N 310N-0108 N500TJAirbyars LLC · Spartanburg, SCBuilt 1974 · S/N 421B0585 N5011QBoh-Air Corporation · Jenks, OKBuilt 1968 · S/N 310N-0111 N5020QHudson Thomas C Jr · Bessemer, ALBuilt 1968 · S/N 310N-0120 N5029QStormont Dylan · Xenia, OHBuilt 1968 · S/N 310N-0129 N502ATAir Note LLC · Delray Beach, FLBuilt 1973 · S/N 421B0547 N5033QChanges In Attitude LLC · Monument, COBuilt 1968 · S/N 310N-0133 N503NAClover Park Technical College · Lakewood, WAS/N 402B-0313 N5045QPuma Aviaton LLC · Tracy City, TNBuilt 1968 · S/N 310N-0145 N5047QRoundy Steve G · St George, UTBuilt 1968 · S/N 310N-0147 N5052Tashjian Kirk G · Stanwood, WABuilt 1958 · S/N 38091 N5052QSwanson Rodney Blake · Katy, TXBuilt 1968 · S/N 310N-0152 N5053QHoovers Truck & Equipment LLC · Dover, OHBuilt 1968 · S/N 310N-0153 N5057QCloud Dancer Aviation LLC · Chino Hills, CAS/N 310N-0157 N505CMStout Walter J · White Hills, AZBuilt 1968 · S/N 310N-0155 N505RWCor Group LLC · Arlington, WAS/N 421B0268 N5063QNorthern Hydraulic Dredge Co Inc · Harrisville, MIBuilt 1968 · S/N 310N-0163 N5066QChristen Darryl K · Houma, LABuilt 1968 · S/N 310N-0166 N5067QTuckey Patrick · Waxahachie, TXBuilt 1968 · S/N 310N-0167

Back to AD 72-14-08 R1