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.
N902APPollard Aircraft Sales Inc · Fort Worth, TXN902AZSantiago Felipe · Miami, FLN902CWhite Edwin W · Eagle River, AKN902CCVan Flve Klub Inc · Holt, MNN902EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN902FAVero Technical Support Inc · Pensacola, FLN902FCSkyborne Airline Academy Inc · Vero Beach, FLN902GRWright Allan M · Los Gatos, CAN902HMacvey Troy R · Milan, INN902NSRegistration Pending · Pottstown, PARegistration pendingN902PADefranco Peter Jr · Hueytown, ALN902SAWild Wings Aviation Inc · Wilmington, DENon-citizen corporation, flight hours not reportedN902SCCampbell Steven · Tipp City, OHN90309Roe David N · Santa Fe, NMN9030FDesouza Ferdinand E · El Prado, NMN9030JSunrise Aviation Group LLC · Kalispell, MTN9030LDavis Robert L · Seymour, TNN9031JBaumgartner Matthew J · Federal Way, WAN9031LSanderlin Doulgas C · Wasilla, AKN90322State Of Alaska Department Of Public Safety · Anchorage, AKN9032CGoodman Kim J · Burnsville, NCN9032LJohnson Robert W · Buffalo, SDN9032WPringle Craig Marlin · Winfield, KSN9033JBernstein Matthew D · North Charleston, SCN9033LBickmore David L · Bay City, MIN90343Kay R Steven · Riverside, CAN90346Mittelsted John J · Dickinson, TXN90347R & S Aircraft LLC · Wilmington, DEN9034JGrammer Steve J · Redding, CAN9036BVan Bortel Aircraft Inc · Arlington, TXN9036DKranz Monte L · Eagle Butte, SDN9036JBernau Bodies Fitness LLC · Mesa, AZN9036KGriffiths Gregory S · Johnson City, NYN9036LWhitmer Charles W · Fairbanks, AKN9036NRobinson Helicopter Co · Torrance, CAN9036RBaltz David M · Superior, CON90371Jackson Thomas M · Mckinney, TXN9037JMcgough Julie E · Red Oak, TXN9038DJones Michael D · Eagle River, AKN9038FGrupp Wayne · Wayne, ILN9038HPeterson Todd B · Cameron Park, CAN9038KNorthwest Aviation LLC · Gig Harbor, WAN9038YRodriguez Juan M · Grass Valley, CAN90391Meyer Florence Trustee · Billings, MTN90392Parsons Walter E · Clinton, NCN9039CDouble O Seven Limited Co · Carefree, AZN9039LBowman Eagles Inc · Louisville, KYN903CPCivil Air Patrol Inc · Maxwell Afb, ALN903DRCrosgrove Shawn R · Riverton, UTN903EESkywest Leasing Inc · St George, UT
Back to AD 81-18-04 R2