Skip to content

Registered aircraft · 25,370

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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.

N4843BMaddox Emily Brown · Rosharon, TXBuilt 1979 · S/N 15283668 N4843RFriesenborg & Larson Custom Spraying Lc · Buffalo Center, IABuilt 1975 · S/N 18802362T N48440Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15280910 N4844FKnightair Enterprises LLC · Caro, MIFirst renewal noticeBuilt 1979 · S/N 17273088 N4844JSkoglun Eric W · Cashmere, WABuilt 1979 · S/N 17273684 N4844KMccoy Robert G Jr · Marshville, NCBuilt 1979 · S/N P21000344 N4845CBloss Albert P · Seattle, WABuilt 1979 · S/N 21063642 N4845GNation Linda S · Sanford, FLBuilt 1979 · S/N 17273392 N4845JL&J Aviation Inc · Atwater, CABuilt 1979 · S/N 17273685 N4846GNavy Annapolis Flight Center Inc · Edgewater, MDBuilt 1979 · S/N 17273393 N4847BCrossbrook LLC · Willoughby, OHBuilt 1979 · S/N 15283670 N4847GFlying Daze · Batavia, OHBuilt 1979 · S/N 17273394 N48481Oklahoma State University · Stillwater, OKBuilt 1979 · S/N 15283342 N4849DN4849d LLC · North Logan, UTBuilt 1979 · S/N 17272372 N4849JEast Side Mosquito Abatement District · Modesto, CABuilt 1981 · S/N 18803773T N4849QSouther Field Aviation Inc · Americus, GABuilt 1976 · S/N 18802585T N484ACReist David A · Mount Joy, PABuilt 1999 · S/N 425-99 N484KWNunez-Fontes Fernando · Rio Rico, AZBuilt 1980 · S/N 21064066 N484MAGibby Aviation Inc · Wilmington, DEBuilt 2014 · S/N 1147-2014 N48500R&R Aero Services LLC · Eden Prairie, MNBuilt 1977 · S/N 15280914 N4850GPeters Walter C · Rockford, ILBuilt 1979 · S/N 17273397 N4850HGreen Airport Development Corp · Kemah, TXBuilt 1979 · S/N 15283985 N4850SWood Josh A · Chino Hills, CAS/N R182201438 N4851BCode Supplies Inc · Lakeland, TNBuilt 1979 · S/N 15283673 N4851GEye Candy Aviation LLC · Jacksonville, FLBuilt 1979 · S/N 17273398 N4851JAbernathy Spraying Service Inc · Tipton, OKBuilt 1981 · S/N 18803774T N48521Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1979 · S/N 15283346 N4852GR&R Aero Services LLC · Eden Prairie, MNBuilt 1979 · S/N 17273399 N4852PGreenwood Auto LLC · Itta Bena, MSBuilt 1980 · S/N 15284831 N4852VR & R Aviation Services LLC · Darien, ILS/N 172RG0400 N48549Davies Richard E · Sequim, WABuilt 1979 · S/N 15283349 N4854GMilwaukee Aero LLC · Milwaukee, WIBuilt 1979 · S/N 17273401 N4854RFisher Ag Service LLC · Cardington, OHBuilt 1975 · S/N 18802373T N4855GWings Over Texas Holdings LLC · Denton, TXBuilt 1979 · S/N 17273402 N4855RDefty Peter A · Visalia, CAS/N 18802374T N48568Spartan Education LLC · Tulsa, OKBuilt 1979 · S/N 15283350 N4856DOlsen Ernest D · Lino Lakes, MNBuilt 1979 · S/N 17272374 N4856GNatchez Flight Training LLC · Natchez, MSBuilt 1979 · S/N 17273403 N4856THub City Aviation LLC · Spartanburg, SCFirst renewal noticeBuilt 1981 · S/N R18201777 N4856VColombie Michael A · Anchorage, AKBuilt 1980 · S/N 172RG0401 N4857CGate Holdings LLC · Ketchum, IDBuilt 1979 · S/N 21063647 N4857GVero Technical Support Inc · Pensacola, FLS/N 17273404 N4857VNewsouth Aviation LLC · Auburn, ALBuilt 1980 · S/N 172RG0402 N48581Luis Enrique Quintana · Miami, FLS/N 15283351 N4858PGreat Plains Spraying Inc · Colby, KSBuilt 1978 · S/N P21000122 N48590Heavy Metal Air LLC · Farmingdale, NYS/N 15280920 N4859FRidgway Stephen · Avon, COBuilt 1979 · S/N 17273089 N4859GAirgo Inc · Centralia, ILBuilt 1979 · S/N 17273406 N485GRegistered aircraftBuilt 1980 · S/N 172RG0306 N485SBLyddon Aero Center Inc · Liberal, KSBuilt 1978 · S/N 17271485

Back to AD 80-25-07 R1