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.
N9765JPinson Cassandra · Chandler, AZN9765LMartone Aviation LLC · Ocala, FLN9765MMahoney James P · Renton, WAN9765WShelby Gary J · Harleysville, PAN97662Northwest Alabama Holdings LLC · Spruce Pine, ALN9766DMayer Gregory B · Fall River Mills, CAN9766WYoung Justice P · Prairie Grove, ARN97674Oc Flight Lessons LLC · Costa Mesa, CAN9767JMatta Aviation Services LLC · Junction City, KSN9767MMcgill James D · Tucson, AZN9767PVanhorne Robert E · Centralia, ILN9767WBrighton Flying Club LLC · Brighton, MIN97681Buiqui Aerospace Corp · Kissimmee, FLN9768CHansen Kurt C · Washington, UTN9768JOpp Prop Air LLC · Collierville, TNN9768WEichner Cynthia A Loening · Tolland, CTN9769FFrost Aviation Services Inc · Las Cruces, NMN9769JDubovtsev Mikhail · Wildwood, NJN976ACNaples Air Center Inc · Naples, FLN976AZWl Aviation LLC · Boca Raton, FLN976BEAero Sphere Inc · Mcclellan, CAN976CAFlydreams Aircraft Group Inc · Fort Lauderdale, FLN976CPCivil Air Patrol · Maxwell Afb, ALN976DBSchlittenhardt Ronald K · Saint Francis, KSN976DPKnox John R · Arvada, CON976DRRed 6 Technologies LLC · Santa Monica, CAN976LSSmith Lawrence B · Clovis, CAN976MAZephyr Ventures Inc · Wilmington, DEN976MSStaten Joseph A · Kitty Hawk, NCN976PShahen Michael A III · Belleville, ILN97702Smith Jeffrey W · Yakima, WAN9770UPlegge Timothy E · Granbury, TXN9770WRegistration Pending · Altus, OKRegistration pendingN9771DHull Christian M · Palmer, AKN9771JBuzzard Roost Aviation LLC · Marble, NCN9771LLarson Steven E · Columbus, NEN9771QAerospec Insurance LLC · Gig Harbor, WAN9771TTrevisan Hugo S · Polk City, FLN9772WCow Dog Flyers LLC · Bozeman, MTN9773BChagres Flight Training LLC · Albuquerque, NMN9773J1st Flight LLC · Granby, CON9773UEnos Matthew · Jackson, MON97749Beck Shylan · Blanding, UTN9774BWagner Michael D · Winter, WIN9774DRegistration Pending · Wolf Point, MTRegistration pendingN9774FTailwind Aviation Solutions LLC · Perry, GAN9774WAmerican Patrols Inc · Midland, TXN97755Civil Air Patrol Inc · Maxwell Afb, ALN9775BAequalis Photography Corp · Tacoma, WAFirst renewal noticeN9775LLassiter Jason T DBA · Ephrata, PA
Back to AD 81-18-04 R2