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.
N9534JTock Robert · Saint Paul, MON9534LPowley Robert L · Mahwah, NJN9534UDavis Allen J · Weidman, MIN95357Kidd Keith W · Covington, KYN9535HNorthwest Wings LLC · Hillsboro, ORN9535JBradley D Schnell · Mequon, WIN9535MGillman Charles J · Houston, TXN9535WEast Carolina Aviation LLC · Camden, NCN95364Hostetler Joseph A · Brownsburg, INN95365Mason Brent M · Clarksville, FLN95369Szmurlo Steven R · Easton, PAN9536DCalifornia Management And Consulting LLC · North Hollywood, CAN9536FTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN9536HSampson Kelly J · Canby, ORN9536JGalata Aviation Services LLC · Autsin, TXN9536LFarris Thomas B · Henderson, NVN9536SExpress Aviation LLC · Philadelphia, MSN9536WOwen Christopher D · Molt, MTN95374Board Of Trustees DBA · Murphysboro, ILN95376Team K Outfitters LLC · Memphis, MON9537CArcher II LLC · Kenosha, WIN9537LPence Jeffrey S · Edinburg, VAN9537MWatts Brett M · Prescott, AZN9537QBoeing Empolyees Flying Assn · Renton, WAN9537SHowell Alice R · Bainbridge, GAN9537WOlson Douglas C · Buffalo, MNN95381Gray Dennis P · Le Roy, NYN95383Wolter Michael S · Dallas, TXN9538CCobb Janet · Saint Joseph, MON9538HK & L Air Inc · Brazil, INN9538UMoxom Jeremy · Raleigh, NCN9538WField James E · Kendallville, INN95391Training Planes LLC · Tampa, FLN9539BThree Rivers Limousine Service Inc · Pittsburgh, PAN9539CNafziger Aviation Leasing LLC · Wittman, MDN9539DBohemia Aviation LLC · Niagara, WIN9539LSt Pete Aviation Services LLC · Saint Petersburg, FLN9539MPfaltzgraff George E A · Solon Springs, WIN9539PNichols Aviation LLC · Middletown, DEN9539RAdams Scott A · Glenview, ILN9539UFletchair Inc · Comfort, TXN953ACConeburripul Corp · Miami, FLN953AFRegistration Pending · Addison, TXRegistration pendingN953BCCammarata Robert Jr · Greensburg, PAN953BLMeier James A · Lac Du Flambeau, WIN953CNEllison Craig · Sandpoint, IDN953DYNeiger Steven W · Portland, ORN953EPratt David E · Jefferson City, MON953GArcher Flight LLC · Wilmington, DEN953GBFunnemark Dennis F · Niceville, FL
Back to AD 81-18-04 R2