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.
N8958DPoulton Daniel D · Belton, SCN8958JDavis William M · New Lenox, ILN8958LBarron John C · Tulsa, OKN8958PVan Dyke David M · Portland, ORN8958VHyldburg Aviation Inc · Plymouth, MAN89594Executive Aviation LLC · Peoria, AZN8959CHanson Dan H · Lusk, WYN8959JRegistration Pending · Fairmont, WVRegistration pendingN895AFAmeriflyers Of Texas Inc · Addison, TXN895AGProffetty Stephen D · Bridgewater, MAN895DSGuida Associates Consulting Inc · Sandpoint, IDN895NDUniversity Of North Dakota · Grand Forks, NDN895TCHeisecke Raul Torres · Tyler, TXN895VSpurlock Ricky DBA · Jensen, UTN89600Philbrick Rodney C DBA · Bishop, CAN8960CChristensen Todd S · Wasilla, AKN8960JRegistered aircraftFirst renewal noticeN8961CHuguenard Jefferson · Alpharetta, GAN8961LStanton Kathleen Z · Burneyville, OKN8961VHampton Flying Services LLC · Portsmouth, NHN8961ZHein-Reece Linda K · Shelton, WAN8962FEmbry Aero Ltd · Greenville, ILN8962JStory Allen D · Arlington, TXN8962MAshcraft Todd W · Elgin, ILN8962YChoate Cass Joseph · Toone, TNN8963DDoyle Patrick H · Keller, TXN8963YNess Rent A Car Inc · Fargo, NDN896482fly-Safety LLC Trustee · Azle, TXN8964DThomas Daniel C · Shady Shores, TXN8964JKemper Kevin K · Granite Bay, CAN8964VOneill Jared · Gilroy, CAN8964W3720 To 1 Inc · Greenwood Village, CON89652Lexington Flying Club Inc · Lexington, KYN89653Hillsboro Aero Academy LLC · Hillsboro, ORN8965CMisner Darrell R · Kasilof, AKN8965DSale Reported · Beech Creek, PASale reportedN8965JN8965j LLC · Anchorage, AKN8965LWeber Daniel M · Oconomowoc, WIN8965WWarlick Bradley Q · Negaunee, MIN8965YLucid Thought Consulting LLC · Terre Haute, INN89661Kelly William W · Springfield, ORN89664Mulligan James Michael Trustee · Mesa, AZN8966DDodd Robert L · Humboldt, IAN8966JBrown Bradford K · Leoti, KSN8966LMoffatt Thomas O · Kennesaw, GAN8966VCreider Paul E · Tulsa, OKN8967JJust Plane Fun LLC · Sunrise, FLN8967LGoertz Anton O · Santa Fe, NMN8967TKellys Flying Service LLC · Warrensburg, MON8967YQualitair LLC Trustee · Michelstadt
Back to AD 81-18-04 R2