AD 87-10-06 R1
Registered aircraft · 72,010
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:87-10-06-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1')
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:87-10-06-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1') 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.
N9JSAuburn Flight Time LLC · Auburn, ALN9JTEverything Pitts LLC · Queen Creek, AZN9JUVaneau Philip · Wasilla, AKN9JWDrozd Thomas · Lake Dallas, TXN9KDGerada Matthew T · Bossier City, LAN9KKWessel Marvin E Jr · Camp Verde, AZN9KPEmmons Russell S · Waterbury, CTN9KRDavis Joshua A · Warner Robins, GAN9KTJacelon Charles E · Little River, SCN9KULafever George Alan · Tucson, AZN9KZGlasgow James G · Stamping Ground, KYN9LEdwards Allan E · Oakland, CAN9LLRegistered aircraftN9LUNoel Michael P · Poplar Grove, ILN9MEArtmann James · Zimmerman, MNN9MGRossmann William L · Hillsborough, NJN9MLBobcheeto LLC · Newark, DEN9MYBermudez Tacito Octavio · Conyers, GAN9MZPeterson Wayne W · Burlington, WIN9NADmj Air LLC · Souris, NDN9NTHigh Times Adventure Co LLC · Columbiana, ALN9NYDanner Jason · Burleson, TXN9PASteckner Michael · Beachwood, OHN9PBUnderwood David G Trustee · Naperville, ILN9PEN9pe LLC · Locust Grove, GAN9PMNdlebe Isabella L · Okemos, MIN9PTDonnelly Mark J · Newborn, GAN9QExecutive Express LLC · Elizabeth City, NCN9QAVerwolf Phil A · Broadus, MTN9QBNorthern Aviation LLC · Palmer, AKN9QTJakes Airventures LLC · Carmel, CAN9QYAmelia Air LLC · Naples, FLN9RXKovach Kim A · Ocala, FLN9SAN9sa Corp Trustee · Wilmington, DEN9SVPaul Guy M · West Columbia, TXN9TARhynette Airways LLC · Key Largo, FLN9TXRegistration Pending · San Ysidro, CARegistration pending, canceledN9TZHarfst Michael · Milwaukie, ORN9UFElliott Michael R · Friendswood, TXN9VGOak Tree Title Of Oklahoma LLC · Oklahoma City, OKN9VMSher Lease LLC · Pelican Rapids, MNN9VVAviation Museum At Garner Field Inc · Uvalde, TXN9VXLillie Bruce · Orlando, FLN9WDAngle Matthew · Teton Village, WYN9WKRegistration Pending · Paradise, TXRegistration pendingN9WPMclamore S Whitman · Tampa, FLN9WUHartman Matthew F · Billings, MTN9WZDiesel Doctors Of Lake City Inc · Lake City, FLN9XER A F S LLC · Reno, NVN9XFBounds Keith A · Thomson, GA
Back to AD 87-10-06 R1