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.
N8192YPlane Fun Inc Tr Trustee · Snellville, GAN81936Registered aircraftN8193WButler Austen James · Charlotte, NCN8193ZIa Il Termite & Pest Control Inc · Davenport, IAN8194CWilliams Mark S · Lisbon, OHN8194DPalin Todd M · Wasilla, AKN8194JTipton Aero Shares LLC · Fort Meade, MDN8194KLawair Ltd · Mattoon, ILN8194PMarrs Walter Scott · Chino, CAN81956Blue Skies Leasing Inc · Port Orange, FLN8195AMundorf John P · Mullen, NEN8195DGray Richard B · Manley Hot Springs, AKN8195EKummer Richard L · Dallas, TXN8195PBoddington Aviation LLC · Portland, TXN8195WN7396w LLC · Coeymans Hollow, NYN8195YReynolds Richard T · Owens Cross Roads, ALN81962Sterling Colleen M Trustee · El Cajon, CAN8196CStrout Carl D · Centerburg, OHN8196NJensen Aviation LLC · Zephyrhills, FLN8196WRensberger Scott C · Lake Jackson, TXN8197Walsh Dennis Executor Et Al · Little Falls, NYN81972Reile Roy H · Elmont, NYN8197YTyer Larry E Jr · Newnan, GAN81981Miloud Chadd K · Fort Worth, TXN81988Kephart John M · Franklin, INN8198AMorris Charles R · Holly, MIN8198CLee Jesse D · Pierre, SDN8198HEckl James M · Florence, ALN8198NSpooner John R Jr · Atascadero, CAN8198VRegion Flyers LLC · Valparaiso, INN8198WGreenshields Brett William · Eastvale, CAN8198YRoss Brian L · Eagle River, WIN8198ZPlatz Trevor · Pine Grove, CAN81991Pruitt Frank C · Winter Springs, FLN81999Schwartz Kenneth G · Lincoln, CAN8199CKiokun Edward I · Mekoryuk, AKN8199YMartin Luciano Trustee · Yorba Linda, CAN819ATSeminole Aircraft LLC · Wilmington, DEN819BABig Bend Community College · Moses Lake, WAN819CFParlor City Flying Club Inc · Bloomsburg, PAN819CPCivil Air Patrol · Maxwell Afb, ALN819DJMaljaars Jack A · Prosser, WAN819DWMarchio Anthony J · Flower Mound, TXN819EJLietzan Ernest W · Appleton, WIN819EPTextron Aviation Inc · Wichita, KSN819EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN819GHFincher James B · Roanoke, ALN819HPSombra Aire LLC · Dover, DEN819JBChance Billy M · Normangee, TXN819JKHaviland John G · Fenton, MI
Back to AD 81-18-04 R2