Skip to content

Registered aircraft · 559

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:76-23-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:76-23-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:76-23-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:76-23-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:76-23-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:76-23-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.

N4003BHenderson James A · Flomaton, ALBuilt 1974 · S/N 75-30730 N4023BSachs Robert W · Green Cove Springs, FLBuilt 1974 · S/N 75-30763 N4025BPalmer James F · Walla Walla, WABuilt 1975 · S/N 75-30743 N4033BHawkins Nathan C · Pueblo, COS/N 75-32-153 N4034BRegistration Pending · Sheridan, WYRegistration pending, pending cancellationBuilt 1975 · S/N 75-30790 N4038BHarris James Thomas · Churubusco, INBuilt 1976 · S/N 76-30822 N4039BParish Aviation LLC · Earth, TXS/N 75-30733 N4046BWildeson Dwight L · Troutdale, ORS/N 75-30788 N4052BHatter Ronnie · Newcastle, OKBuilt 1976 · S/N 76-30813 N4053BCavenagh Thomas D · Lawton, OKBuilt 1975 · S/N 76-30797 N4054BKing Ronald S Jr · Goldsby, OKBuilt 1976 · S/N 76-30831 N4055BViking Aviation LLC · York, NEBuilt 1974 · S/N 75-32-151 N4057BKaler Wayne J · Sayville, NYBuilt 1974 · S/N 75-30739 N4059BLyster Michael · Lake Havasu City, AZBuilt 1975 · S/N 76-30809 N4065BTaylor Mitchell · Lodi, CABuilt 1976 · S/N 76-30847 N4080BIbrahim Phillip · Whitinsville, MABuilt 1974 · S/N 75-32-150 N4081BCooley George · Cedar Rapids, IABuilt 1975 · S/N 75-32-161 N4082BJdj Inc · Mountain Home, ARBuilt 1977 · S/N 77-30850 N4085BMarroquin Jesse B DBA · Schertz, TXBuilt 1976 · S/N 76-30821 N4094BClosson Luke E Jr · Valdosta, GABuilt 1975 · S/N 75-30782 N4109BMccowan Joseph F · Sylvania, OHBuilt 1974 · S/N 75-30760 N4113BRishell Charles G · Columbia, MDBuilt 1974 · S/N 74-32-145 N4133BMachinerywatch.Com Inc · Louisa, VABuilt 1975 · S/N 75-30795 N4135BBice Christopher S · Summerville, SCS/N 76-30808 N4137BWalker James D · Grapevine, TXBuilt 1974 · S/N 75-30738 N4141BWright Eric K Sr · Wills Point, TXBuilt 1975 · S/N 75-32-160 N4151BCraig Scott W · Sorento, ILBuilt 1974 · S/N 75-32-152 N4156BNance Gerald D · Bladenboro, NCBuilt 1975 · S/N 75-30789 N4157BHarboe Nicolaus C · Bartow, FLBuilt 1974 · S/N 75-30729 N4158BCapristo Construction · Cape Coral, FLS/N 76-30801 N4165BGood Decision Aviators LLC · Noble, OKBuilt 1975 · S/N 76-30799 N4173BBeck Nicholas G · Ione, CABuilt 1975 · S/N 75-30792 N4176BWard William R · Titusville, FLBuilt 1975 · S/N 75-30781 N4181BOsterberg Douglas L · Neenah, WIS/N 75-30770 N4184BWitt Aaron K · Hooker, OKBuilt 1974 · S/N 75-30742 N4201BNrnc LLC · Camden, DEBuilt 1975 · S/N 75-30775 N4204BLieske William R · Lonsdale, MNBuilt 1974 · S/N 75-30753 N4205BStasson Robert K · Sikes, LABuilt 1974 · S/N 75-32-146 N4210BAkin Andrew D · Senoia, GAS/N 75-30757 N4241BBor-It Mfg Co Inc · Ashland, OHBuilt 1974 · S/N 75-30727 N4243B43 Bravo LLC · Maple Grove, MNBuilt 1974 · S/N 74-30724 N425BBGarcia Robert Lee · Horseshoe Bay, TXBuilt 1968 · S/N 30099 N429FSSimmons Frederick G · Lake Hiawatha, NJBuilt 1971 · S/N 32-54 N432DMRegistered aircraftSale reported, pending cancellationBuilt 1971 · S/N 30413 N4365VPfander Scott J · Litchfield Park, AZBuilt 1972 · S/N 73-30487 N4440BHaustrom Curtis R · Barnesville, OHS/N 73-30614 N44TLEco-Logic Environmental Engineering Inc · Placentia, CABuilt 1979 · S/N 80-30973 N452SKAlcock Shane Vincent · Temple, TXBuilt 1972 · S/N 73-30522 N4702VBrown Anthony · Pacoima, CABuilt 1967 · S/N 30053 N4703VLangham William Hb · Uvalde, TXBuilt 1967 · S/N 30054

Back to AD 76-23-03 R1