AD 81-18-04 R2
Registered aircraft · 81,733
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
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:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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.
N6469QBurl Jeffrey B · Hancock, MIN6469RBaboul Anwar G · Carmel, INN6469USoares Marcus K · Boca Raton, FLN6469WPivotal Aviation LLC · Spartanburg, SCN646AMMiller Alec M · Nampa, IDN646CBJeffery & Weiss Holdings LLC · Long Beach, CAN646DGFulton Todd C · Sacramento, CAN646DWChristiansen Aviation LLC · Wilmington, DEN646FBBourque Ronny Joseph Marc · Santa Maria, CAN646FCFlorida Dept Of Agriculture And Consumer Services · Tallahassee, FLN646FLTaylor William L · Fairfield, ILN646FTFlorida Institute Of Technology · Melbourne, FLN646HStyer David B · Milton Freewater, ORN646JMChapman Johnny Darrell · Douglasville, GAN646KWHely Aviation LLC · Columbus, INN646NDUnd Aerospace Foundation · Grand Forks, NDN646RVImagine Air LLC · Nogales, AZN646SAAbc Aviation LLC · Floresville, TXN646SBBurris Chris E · Larned, KSN646SDBiton Liad · San Diego, CAN646SPVermeylen Donna Lynn · Altamont, TNN6470JSitlinger Angela R · Gratz, PAN6470RAlterio Mark G · North Andover, MAN6470WO'Kelly Albert · Caruthers, CAN6470ZNorthern California Soaring Association · Byron, CAN64717Top Aviation Services Inc · Weston, FLN6471JMartinez Paul · Sonora, TXN6471PWare Patrick D · Farwell, TXN6471QNugent Todd · Lake Bluff, ILN6471RStraw Robert D · Farmington, MNN64728Systir Aviation LLC · Pittsburgh, PAN6472JFAA Flying Club Inc · Springfield, VAN6472QCornay Louis J Jr · Franklin, TNN6472RWilson Richard J · Naknek, AKN6472WSilaban Chandra · Independence, KYN64732A And J Aviation Services LLC · Okeechobee, FLN64736American Patrols Inc · Midland, TXN64739Registered aircraftN6473DTurner Glenn · West Melbourne, FLN6473ECallaham Myron · Bowling Green, KYN6473UCardinal Exploration LLC · Northville, MIN6474JBenham Miriam · Elk Grove, CAN6474QSale Reported · Sarasota, FLSale reported, canceledN6474ZKoenig Donald J · Las Animas, CON64754Aerofeather Aviation Inc · Suffolk, VAN6475DDarcy Aviation LLC · Danbury, CTN6475JClark Clyde E · Naknek, AKN6475QFlying Particles Inc · Livermore, CAN6475UVermilyea Ian · Pensacola, FLN6475WJ K Merrill And Sons Inc · Pocatello, ID
Back to AD 81-18-04 R2