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.
N956RWTrevitue LLC · San Antonio, TXN956SLLittle James S · Douglass, TXN956SMMississippi Forestry Commission · Pearl, MSN956SPN3812q LLC · San Diego, CAN956TAAir Corriente LLC · Wilmington, DEN956TERaw Logistics LLC · Bethel, NCN9570AUpper Fifteen Inc · Latham, NYN9570JCharlie November Romeo LLC · Denver City, TXN9570UFranken Todd V · Martindale, TXN9570VAwp Holdings LLC · Murphysboro, ILN9571HWings Over Texas Holdings LLC · Denton, TXN9571JMeunier Barry · Rehoboth, MAN9571KOtter Fly LLC · Maricopa, AZN9571MSale Reported · Sacramento, CASale reportedN9571VTempleton John E · Loami, ILN95722Frick Gregory A · Portland, ORN9572AEagle Eye Marketing LLC · Reno, NVN9572HGeneral Aviation LLC · Henderson, NVN9572LJav Air Services LLC · Anchorage, AKN9572VHill Timothy E · Hooks, TXN9572WDr Equipment LLC · Ackerly, TXN9573Styer David B · Pendleton, ORN95737Kent State University · Stow, OHN9573BDocarmo Aviation LLC · Dallas, TXN9573LCrosetto Pierre F · Downey, CAN9573MAndrews Geoffrey M · Stoneham, MAN9573PAerial Banners Inc · Pembroke Pines, FLN9573SOppegard Nicholas D · Eagle River, AKN9573VReynolds Darryl G · Wills Point, TXN9573WPyxl Sky LLC · Cogan Station, PAN9574BHinds Community College · Bolton, MSN9574HJb III LLC · Stuart, FLN9574LRiederich John B · Huntington Beach, CAN9574SKrejchik Daniel J · Portage, WIN9575DLaird Cristina R · Fairbanks, AKN9575JJones Anthony J · North Royalton, OHN9575UBarnett Gary L · Bertram, TXN9575VFurnari Alfio · Hutchinson Island, FLN9575WMike Flying Service LLC · Terrell, TXN9576Roznick John A · Stillwater, MNN9576CMercer Paul A · Salida, CAN9576JWright Jason C · Thorntown, INN9576KClearwater Valley Aero Club Inc · Kamiah, IDN9576LBusch Robert M · Duluth, MNN9576MRpm Commander Holdings Inc · Vero Beach, FLN9576PPhiladelphia Glider Council · Hilltown, PAN9577BRegistration Pending · Scottsdale, AZRegistration pendingN9577DBerry Matthew G · Creedmoor, NCN9577JBrown Dennis N · Bakersfield, CAN9577LSquire Barry H · Sarasota, FL
Back to AD 81-18-04 R2