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.
N8659PFiebig Howard James · Sebewaing, MIN8659WFlint Christopher · Tucson, AZN865CKAero American Flight LLC · Houston, TXN865CPAmr Holdings LLC · Kalispell, MTN865CWSouthern Aviation · Anchorage, AKFirst renewal noticeN865DAb Prop Plane II LLC · Metairie, LAN865DMMacniven Donald B · Colorado Springs, CON865ESHangar Ak LLC · Sterling, AKN865GAtp Aircraft 9 LLC · Wilmington, DEN865HBCharlie Alpha Bravo LLC · Spring Hill, KSN865KKDewalt Rodney P · Fort Worth, TXN865LJones Donald · Knoxville, TNN865PAPlatinum Angel LLC · Melbourne, FLN865PBAnthelian Helcopters · Long Beach, CAN865PUTrustees Of Purdue University · West Lafayette, INN865TCQuinault Aviation LLC · Priest River, IDN865VLSale Reported · San Juan, PRSale reportedN865WMichigan Dept Of Natural Resources · Roscommon, MIN865WAYjb Operations LLC · Altoona, PAN86605Gibbons Warren · Toledo, OHN86607Yellow Decathlon LLC · Algonquin, ILN8660DManuella Timothy J · Sandusky, OHN8660NRobbins Jode A · Cameron, WIFirst renewal noticeN8660VStaton Brian L · Lonoke, ARN86612Sale Reported · Wilmington, DESale reportedN86617Teeters Esme · Duncansville, PAN8661DSheets Wayne H · Hagaman, NYN8662Corthell Andrew W · Andover, MNN86621Colson Carl · Blunt, SDN86625Ready Aim Flyer LLC · New Castle, DEN8662CKillen Land & Livestock · Angela, MTN8662VMaxon Raymond D · Santa Paula, CAN8662YCappiello Robert M · Canyon Country, CAN8663Ireland Kel · Fredericksburg, TXN86630Pressley Aviation LLC · New London, NCN86633Gregor John E · Fairbanks, AKN86634Shipp Donald E · Wyoming, MNN86636Olson Kenneth L · Raymond, WAN86637Stohr Beuford G · Woden, IAN8663DLawrence Alexander · Miamisburg, OHN8663WRush Lake Holding Company LLC · Flushing, MIN8664Page Jason · Medina, TNN86641Aa Stearman LLC · Lewisville, TXN86642Tedstrom Robert E · Bartlesville, OKN86647Reuhl Kenneth R · Piscataway, NJN8664CArcher 64c LLC · Essex, MAN8664DWyant David Mark · Dallas, TXN8664FBarney Brooke G · Cresco, PAN8664VCollum Aviation LLC · Milton, FLN8664WWilliams Brian Glenn · Collierville, TN
Back to AD 81-18-04 R2